In this video, the instructor introduces DAX's powerful time intelligence formulas, and demonstrates how to use them to measure performance-to-date, make period-over-period comparisons, and calculate running totals and moving averages.
- [Instructor] So one of the coolest things about DAX…is that they've introduced some incredibly powerful…time intelligence formulas.…And the thing about these formulas…is that it makes it really easy…and really turnkey to calculate common time comparisons.…So, for example, to calculate Performance-To-Date,…you can start with a calculate, evaluate your measure,…and then use the DATESYTD function,…which simply points to your calendar date field,…to produce a year-to-date total for that measure.…Now what's even better is that all you need to do…is swap out YTD with QTD to update that to quarter-to-date,…or MTD for month-to-date.…
We've also got options to calculate…things like the Previous Period,…which can be flexible to adjust…for any kind of period comparisons you need to make.…Things that would be really, really manual and tedious…without having access to these tools.…So, for Previous Period,…you combine calculate with the DATEADD function.…And then, at the end there,…those two components of the formula…allow you to select an interval,…
- 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.