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