X-Functions in Power BI
Power BI X-Functions can be a headache when you first start to use them, the main consideration is - unusually - how many rows a table has. X-functions are iterative, that means they go through a table row by row, perform the DAX expression and then evaluate the results.
Functions
SUMX - Add up DAX expressions
AVERAGEX - Average DAX expression result
MINX - Minimum DAX expression result
MAXX - Maximium DAX expression result
Video mentioned today - • DAX Fridays #154: Dynamic currency convers...
Join us on our website: https://geordieintelligence.co.uk/ww021/
RL021