Time Intelligence
This page contains links to articles, patterns, and tools to implement time intelligence calculations in DAX. You should already be familiar with fundamental DAX notions such as row context, filter context, and context transition, which are covered in The Definitive Guide to DAX book and in our Mastering DAX courses. The sections below provide additional content to improve productivity and get additional insights when implementing time intelligence calculations in a semantic model.
Tools
External tools can be helpful in implementing time intelligence calculations in a semantic model.
- Bravo for Power BI is a tool that can create a Date table and the measures with the time intelligence calculations using predefined and customizable templates.
Articles
For the classic time intelligence, based on the “Mark as Date table” feature that identifies a unique Date column in the Date table, there are articles and videos to introduce and explain how the classic time intelligence functions work:
- Time Intelligence in Power BI Desktop
- Introducing Time Intelligence DAX functions (only SQLBI+ subscribers)
- Understanding Time Intelligence with DAX (only SQLBI+ subscribers)
There are also sever articles with more insights on specific features or use cases:
- Hiding future dates for calculations in DAX
- Filtering weekdays in DAX
- Blank in date columns and DAX time intelligence functions
- Using weekly calendars in Power BI
- Differences between DATEADD and PARALLELPERIOD in DAX
- Computing MTD, QTD, YTD in Power BI for the current period
- Comparing different school terms in Power BI
- Using calculation groups or many-to-many relationships for time intelligence selection
- Show previous 6 months of data from single slicer selection
- Rolling 12 Months Average in DAX
- Previous year up to a certain date
- Year-to-date filtering weekdays in DAX
- Compare equivalent periods in DAX
- Filtering and comparing different time periods with Power BI
- Custom Year-Over-Year Calculation in DAX
- Comparing with previous selected time period in DAX
Patterns
You can find practical examples about how to implement complete calculations using classic time intelligence functions for many scenarios on DAX Patterns:
- Time patterns page is an index of all the patterns available.
- Standard time-related calculations
- Month-related calculations
- Week-related calculations
- Custom time-related calculations