22-25 April 2026 
Calendar-based Time Intelligence in Power BI
Proposed session for SQLBits 2026TL; DR
In this session you will see how easy it is now in Power Bi to set up anykind of non-gregorian calendars and have standard time-intelligence functions on top of it. Furthermore, you will see how the gregorian-calendar time intelligence gets simplified in terms of DAX.
Session Details
Until September 2025, Time Intelligence in Power BI only supported the Gregorian calendar, leaving to the user the burden of defining non-Gregorian calendars. The calendar-based time intelligence functions have changed this scenario. They have been designed to handle any kind of calendar. In this session several examples will be shown, after a detailed dive into the settings needed to use the functionality.
3 things you'll get out of this session
Understand the new Calendar-based Time Intelligence works
Understand how to setup the new Calendar-based Time Intelligence in your Power BI models
See related limitations and workarounds
Speakers
Francesco Bergamaschi's other proposed sessions for 2026
Understanding CALCULATE, the queen of all DAX functions - 2026
Understanding DAX Pillars - 2026
User-Defined Functions (UDFs) in Power BI: overview and applications - 2026
Table Functions in DAX - 2026
Visual Calculation vs Measures in Power BI: which to choose, when and why - 2026
What NOT TO DO in DAX - 2026