22-25 April 2026 
Time Intelligence in Power BI
Proposed session for SQLBits 2026TL; DR
Learn the best practices of using both the classic and the new time intelligence functions in DAX
Session Details
Every Power BI model has dates and the need of calculation over dates to aggregate and compare data, like Year-To-Date, Same-Period-Last-Year, Moving Average, and so on. In 2025 DAX has been enriched with the new calendar-based time intelligence.
In this session we analyze the pros and cons of different approaches (classical versus calendar-based) and we dive into the details of how the new calendar-based time intelligence functions work.
In this session we analyze the pros and cons of different approaches (classical versus calendar-based) and we dive into the details of how the new calendar-based time intelligence functions work.
3 things you'll get out of this session
Learn the classic time intelligence
Learn the new time intelligence
Choose the correct set of functions for your model
Speakers
Alberto Ferrari's other proposed sessions for 2026
DAX Optimization - 2026
First Steps in DAX Optimization - 2026
Introducing DAX user-defined functions - 2026
Why star schema is your best choice in Power BI - 2026