Time Intelligence in Power BI
summary
Walks through building a Power BI tabular model from SQL Server (importing InternetSales, ResellerSales and a Date dimension), shows creating a surrogate date table, mark as date table to enable time intelligence, and writing DAX measures (SUM, TOTALYTD or DATESYTD for year‑to‑date, DATEADD/PARALLELPERIOD for prior‑period and quick measures for year‑over‑year). Demonstrates fixing a date‑gap, refreshing the model, and notes local performance lag; suggests Tabular Editor for calculation groups to avoid duplicating measures.
AI-written summary · about
chapters (12)
- 0:00Start
- 0:09Thomas Leblanc
- 2:26What Is Time Intelligence
- 18:04Weekdays Holidays and Special Date Type Columns
- 21:00Active Relationship
- 23:44T Sql
- 28:21Refresh the Data
- 35:52Quick Measures
- 36:04Quick Measure
- 40:05Create the Calculation Group
- 42:21Auto Date Feature
- 45:52Global Settings
related talks
50mTime Intelligence in Power BI
51mAggregations in Power BI
23mPower BI - Creating a M-agical Date Table
43mBecome a Power BI Data Modeling Wizard using Tabular Editor 3
51mTroubleshooting Power BI Report Performance
51mData modeling for experts with Power BI
48mCombine Power BI with External Tools
54mData Visualization with Power View and the Tabular Model