In this video, the instructor outlines some of his personal favorite 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 nowhere close to a master to be honest.…
- Power Pivots versus normal pivots
- Creating calculated columns and measures
- Power Pivot and DAX best practices
- Math, stats, and COUNT functions
- CALCULATE, FILTER, and ALL functions
- Joining data with RELATED
- Using iterator functions (SUMX and RANKX)
- Time intelligence formulas
Skill Level Intermediate
1. Getting Started
Set expectations1m 46s
2. Power Pivot and DAX 101
3. Common DAX Functions
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.