Created in Power Query by writing a formula in M. Guidance on reducing model size recommends it over adding the equivalent column in DAX, because compression tends to be better and refresh times aren't extended.
Read more: Microsoft Learn
In the Ultra Transcenders books
Each book explains Custom column in context, with comparison tables and the common traps.
Terms in this definition
- OVER
Gives a T-SQL window function its window: PARTITION BY, ORDER BY and, if wanted, a ROWS or RANGE frame. Rankings and running totals can then be worked out while every row is kept.
- DAX
Short for Data Analysis Expressions, the formula language you write measures, calculated columns and row-level security rules in, within tabular semantic models in Power BI, Excel Power Pivot or Analysis Services.