Classic DAX time intelligence works. But it has limits. It only supports Gregorian and shifted Gregorian calendars – no fiscal week calendars, no 4-4-5, no sparse dates. And performance that doesn't always hold up at scale.
Calendar-based time intelligence – also referred to as enhanced DAX time intelligence in Power BI Desktop – changes that. You define one or more named calendars on your date table, reference them directly in DAX, and gain precise control over how time shifts are calculated. Whether you're working with a standard Gregorian calendar, a 4-4-5 fiscal calendar, or a custom week-based structure, the approach is the same: define it once, use it everywhere.
Maria José Ferreira Fernandes (Core Developer) and Jeroen ter Heerdt (Head of Product) show you how it works – from setting up your first calendar in Tabular Editor to writing calendar-aware DAX and verifying results in Power BI.
