Project Botticelli

Status message

See the new version of this article on! Why? Read our announcement.

Time Intelligence in DAX Purchase this course

25 November 2017 · 201 views

Mastering DAX Workshop

Almost every data model includes some sort of calculations related to dates. DAX offers several functions, grouped as time-intelligence, to simplify these calculations, which work fine if the underlying data model respects some specific requirements.

In this section, you will learn how to implement common date-related calculations such as year-to-date, year-over-year, comparisons over years, running total, and moving annual total.

You will see also 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.

After a quick recap, you should practice Lab 5.

Log in or purchase access below to the premium version of this content.