It's about time: Calendar-based time intelligence in Power BI
Proposed session for SQLBits 2026TL; DR
Power BI introduces a calendar-aware engine that lets you define multiple calendar structures directly in your model, opening doors to cleaner, more accurate time calculations without heroic hacks.
Session Details
Traditionally, Power BI’s time intelligence assumed a linear Gregorian calendar and required continuous date tables. This often led developers into complex workarounds for non-standard business calendars such as retail 4-4-5, ISO week structures, or custom fiscal periods.
But now Power BI introduces a calendar-aware engine that lets you define multiple calendar structures directly in your model, opening doors to cleaner, more accurate time calculations without heroic hacks.
That’s all, folks! …unless you want to see calendar-based time intelligence in Power BI in action, then come along for this demo-packed session.
But now Power BI introduces a calendar-aware engine that lets you define multiple calendar structures directly in your model, opening doors to cleaner, more accurate time calculations without heroic hacks.
That’s all, folks! …unless you want to see calendar-based time intelligence in Power BI in action, then come along for this demo-packed session.
3 things you'll get out of this session
How to setup calendar-based time intelligence
How to use them in your reports and measures (E.g., DatesWTD)
Limitations of calendar-based time intelligence
Speakers
Nico Jacobs's other proposed sessions for 2026
Fabric Data Agents - 2026
The Power of Paginated Reports - 2026
What are Fabric Materialized Lake Views - 2026
When Translytical Task Flow meets Fabric Data Function - 2026