Chapter 7. Time intelligence calculations

Almost any data model includes some sort of calculation related to dates. DAX offers several functions to simplify these calculations, which work fine if the underlying data model respects some specific requirements.

In this chapter, you will learn how to implement common date-related calculations such as year-to-date, year-over-year, and comparisons over years, including nonadditive and semi-additive measures. You will learn how to compute both using specific time intelligence functions, and custom DAX code that is required for nonstandard calendars and week-based calculations.

Introduction to time intelligence

Typically, your data model will contain a calendar table. In fact, it is usually better to ...

Get The Definitive Guide to DAX: Business intelligence with Microsoft Excel, SQL Server Analysis Services, and Power BI now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.