This video introduces the new calendar-based time intelligence functions in DAX, available in preview from the September 2025 release of Power BI.
Article and download: https://sql.bi/883518?aff=yt
How to learn DAX: https://www.sqlbi.com/guides/dax/?aff=yt
The definitive guide to DAX: https://www.sqlbi.com/books/the-definitive-guide-to-dax-2nd-edition/?aff=yt
00:00:00 Introduction
00:02:34 What is calendar-based time intelligence
00:07:50 Creating calendars on a date table
00:16:48 Uniqueness in calendar definition
00:22:16 Defining a Gregorian calendar
00:32:19 Defining a Weekly calendar
00:39:30 Lateral shift in calendars
00:47:37 Filter manipulation in calendar-based time intelligence functions
00:57:27 Time-related columns and TMDL view
01:02:13 Final considerations
