Mastering DAX Workshop
Almost every data model includes some sort of calculations related to dates. DAX offers several functions, grouped as time-intelligence, to simplify these calculations, which work fine if the underlying data model respects some specific requirements.
In this section, you will learn how to implement common date-related calculations such as year-to-date, year-over-year, comparisons over years, running total, and moving annual total.
You will see also nonadditive and semi-additive measures. You will learn how to compute both using specific time intelligence functions, and custom DAX code that is required for nonstandard calendars and week-based calculations.
After a quick recap, you should practice Lab 5.
Log in or purchase access below to the premium version of this content.
Working with Iterators
Mastering DAX Workshop (Current)
1.
Introduction to DAX 1-hour 1-minFree
2.
Table Functions 32-min
3.
Evaluation Contexts 42-min
4.
CALCULATE Function 32-min
5.
Evaluation Contexts and Relationships 1-hour 8-min
6.
Building a Date Table 19-min
7.
Working with Iterators 36-min
8.
Time Intelligence in DAX 56-min
9.
Querying with DAX 1-hour 9-min
10.
Hierarchies in DAX 28-min
11.
Advanced Relationships 1-hour 14-min
12.
Lab Exercise Files and Presentation PDF
Purchase A Full Access Subscription
- Payment is instant and you will receive a tax invoice straight away.
- Your satisfaction is paramount: we offer a no-quibble refund guarantee.
Jump to a chapter
- Introduction to Time Intelligence (00:08)
- Aggregations Over Time (00:58)
- Year-to-Date Functions (16:45)
- Previous Year, Year-over-Year, and DATEADD (19:58)
- Example of a Previous Year Calculation (23:13)
- PARALLELPERIOD Function (29:06)
- Running Total (31:51)
- Moving Annual Total (34:39)
- Semi-additive Measures (39:23)
- Calculations Over Weeks (51:37)
- Time Intelligence Summary (54:51)
- Lab 5 (55:40)