From the course: Excel Business Intelligence: Power Pivot and DAX
Unlock this course with a free trial
Join today to access over 22,600 courses taught by industry experts.
DAX best practices - Microsoft Excel Tutorial
From the course: Excel Business Intelligence: Power Pivot and DAX
DAX best practices
- All right, congratulations, you have officially made it to the end of the DAX section of the course. Nicely done, hopefully you learned a ton and got some really awesome, powerful new functions and tools that you can go and start using right away. Now as always, we're gonna close with a few of my favorite best practices. So DAX best practice number one. Write measures even for the simplest calculations. So it might seem silly to calculate something like the sum of sales when you can just drag it in as an implicit measure. Remember, we don't like that approach. So once you create a measure, even if it's a simple one like this, the beauty is that it can be used anywhere in the workbook, and as an input to many other more complex calculations, forming things that we call measure trees. DAX best practice number two. Break your measures down into simple and component parts, especially as you're learning this language. So DAX, to be honest, is a really difficult language to master. I am…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
(Locked)
Introduction to DAX functions27s
-
DAX formula syntax and operators4m 5s
-
(Locked)
Common DAX function categories3m 54s
-
(Locked)
Basic math and stats functions12m 45s
-
(Locked)
COUNT, COUNTA, DISTINCTCOUNT, and COUNTROWS10m 35s
-
(Locked)
Logical Functions (IF, AND, and OR)16m 49s
-
(Locked)
Switch and Switch (TRUE)10m 33s
-
(Locked)
Text functions10m 53s
-
(Locked)
The CALCULATE function14m 39s
-
(Locked)
Add filter context with FILTER: Part 19m 20s
-
(Locked)
Add filter context with FILTER: Part 214m 23s
-
(Locked)
Remove filter context with ALL9m 6s
-
Join data with RELATED3m 39s
-
(Locked)
Iterator ("X") functions: SUMX12m 20s
-
(Locked)
Iterator ("X") functions: RANKX5m 33s
-
(Locked)
Basic date and time functions4m 58s
-
(Locked)
Time intelligence formulas17m 2s
-
(Locked)
Speed and performance considerations3m 2s
-
(Locked)
DAX best practices2m 3s
-
(Locked)
-