Back to Roadmap
Level 4 — Time Intelligence+75 XP
Lesson 1
1. The Date Table Golden Rule
Why time intelligence requires a contiguous date table marked as Date.
The Concept
Time intelligence functions require a dedicated Date table containing full contiguous years without gaps.
Example DAX:
// Reference the Date table's primary key Date[Date] YTD Sales = TOTALYTD([Total Revenue], 'Date'[Date])
Never run time intelligence functions directly on Sales[Date] because transaction tables have date gaps (weekends, holidays), which breaks DAX date logic.
Try It Yourself
Create a measure 'Revenue YTD' using TOTALYTD with [Total Revenue] and Date[Date].
fx
[fx]The Date Table Golden Rule=
Loading DAX Formula Studio...
Type [ for fields