Why - What The DAX?

I want to master Power BI and Fabric and in that pursuit have done the PL-300 (Power BI Data Analyst) and DP-600 Certifications.. An area that I am relatively week in is in fully understanding DAX.

So as part of my journey to master this language have deceided to do a post on each of the DAX Functions and what the use case is.

My idea is to get a list of all the DAX functions, put them into Excel and then randomly select a function every day 

Randomly Select a Function to look at every day

Methodology

Step 1 : Get a list of DAX Funcitons : Went to https://dax.guide/functions/ and copy and pasted to Excel

As at 13th October 2024 - How Many DAX Functions are there?

                                    443

Step 2 : Put into Excel and put in a rownumber next to each function

Step 3: In a Cell put in the following Function =Randombetween(1, 443)

On pressing F9 The cell recalculates, randomly generating the row number with a DAX Function to look at.

Step 4: Write Post about DAX Function and grey out in Excel

Google search the function and learn more about the function and the use case. Try to do an example in Power BI