Topic: Time Intelligence
-
This article introduces the new calendar-based time intelligence functions in DAX, available in preview from the September 2025 release of Power BI. Read more
-
When using time intelligence functions, the automatic REMOVEFILTERS on Date can make maintaining filters on the Date table challenging. This article shows a technique to handle filter-preserving columns in DAX. Read more
-
I usually do not write about announcements and new features until we have had time to try and test them in the real world. However, there are always exceptions, and some of the announcements at the Microsoft Fabric Conference 2025… Read more
-
This article explores the implications of having blank values in date columns and provides the best practices for managing them in DAX calculations and Power BI reports. Read more
-
This article describes why week-based calendars (like 4-4-5) are important for specific industries and how to use them effectively in Power BI. Read more
-
This article describes the difference between the results of DATEADD and PARALLELPERIOD in DAX. These differences also impact many other time intelligence functions that are syntax sugar of these two. Read more
-
The different results of DATEADD and PARALLELPERIOD in DAX may impact many other time intelligence functions that are syntax sugar of these two. Watch now
-
This article describes how to use the DAX time intelligence calculations applied to the latest period available in the data, also known as the “current” period. Read more
-
How to implement the comparison between school terms. The same technique can be applied to any arbitrary time periods that do not match regular months or quarters in a calendar, such as seasons or campaigns. Watch now
-
This article describes a reference Date table in DAX using a Power BI template. The same technique can be used in Analysis Services models. Download the latest version of the template in the Dax Date Template page. Read more
