Top 10 DAX Functions For Beginners


#1

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


#2

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