Project Botticelli

Time Intelligence in DAX Purchase this course

25 November 2017 · 161 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.

Purchase This Course or Full Access Subscription

Single Course

$350/once

Access this course for its lifetime*.
Purchase
Subscription Best Value

$480/year

Access all content on this site for 1 year.
Purchase
Group Purchase

from $480/year

For small business & enterprise.
Group Purchase

  • Redeem a prepaid code
  • Payment is instant and you will receive a tax invoice straight away.
  • Your satisfaction is paramount: we offer a no-quibble refund guarantee.

* We guarantee each course to be available for at least 2 years from today, unless marked above with a date as a Course Retiring.

Online Courses