Mastering Time-Based Analysis in DAX
summary
Practical recipe for date-driven DAX: use a designated date table marked as such, rely on 35 built-in time functions for YTD/MTD/QTD, and force filter context with calculate + parallelperiod to get prior-period comparisons. Build a small linked "periods" table to switch measures, implement semi-additive snapshots with the last non-blank pattern to sum stores but take last daily balance, and find the day of maximum sales by combining VALUES, MAXX and FIRSTDATE. Patterns work; demos show they run in Power Pivot.
AI-written summary · about
chapters (11)
- 0:00Introduction
- 1:24Measures vs columns in DAX
- 5:42Filter context in DAX
- 11:55Date table in DAX
- 17:57Built-in time intelligence
- 20:18YTD and period comparisons
- 32:09Dynamic period sales
- 38:22Semi-additive measures
- 45:30Max values and dates
- 54:12Advanced time analysis
- 59:16Q&A
related talks
58mInventory Valuation Techniques with DAX and Tabular Models
51mData modeling for experts with Power BI
16mGood Data Modeling & Effective Communication in Power BI
19mTimespan Fact Tables
58mBeginners Guide to MDX
49mModern T SQL for Better Performance
22mUsing ALLEXCEPT or ALL/VALUES?
20mLet's Improve the Tabular Model by Combining Queries