What 10 functions would you consider to be must learn functions someone new to DAX should learn and master in detail?
Of course CALCULATE but what would you consider to be the others?
Dave
What 10 functions would you consider to be must learn functions someone new to DAX should learn and master in detail?
Of course CALCULATE but what would you consider to be the others?
Dave
Hi Dave,
I would break it down like this, as learning the three TYPES of functions and how they work is just as or even more so important than learning a specific function.
So I would say this
AGGREGATIONS
SUM, AVERAGE, COUNTROWS
ITERATIONS
SUMX/ AVERAGEX
Then, CALCULATE
TABLE FUNCTIONS
FILTER, ALL, VALUES, DATEADD
You can do plenty which just these.
Chrs