22-25 April 2026

It's about time: Calendar-based time intelligence in Power BI

Proposed session for SQLBits 2026

TL; 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.

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