Calendar-based Time Intelligence in Power BI

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.

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.

Speaker

Francesco Bergamaschi's Sessions

Calendar-based Time Intelligence in Power BI

Understanding CALCULATE, the queen of all DAX functions

User-Defined Functions (UDFs) in Power BI: overview and applications

Table Functions in DAX

Visual Calculation vs Measures in Power BI: which to choose, when and why

What NOT TO DO in DAX