Topic: Time Intelligence

        Page 3 of 24 posts
article –

Custom Year-Over-Year Calculation in DAX

This article describes how to implement a custom year-over-year calculation in DAX based on arbitrary associations between different periods. As an example, we describe the comparison of the 53rd week in a ISO Calendar.  Read more

article –

Rolling 12 Months Average in DAX

Computing the rolling 12-months average in DAX looks simple, but it hides some level of complexity. This article explains how to write the best possible formula and how to avoid common pitfalls using time intelligence functions.  Read more

article –

Semi-Additive Measures in DAX (for Power Pivot)

Values such as inventory and balance account, usually calculated from a snapshot table, require the use of semi-additive measures. In Multidimensional you have specific aggregation types, like LastChild and LastNonEmpty. In PowerPivot and Tabular you use DAX, which is flexible…  Read more

article –

Week-Based Time Intelligence in DAX

The DAX language provides several Time Intelligence functions that simplify writing calculations such as year-to-date (YTD), year-over-year (YOY) and so on. However, if you have a special calendar structure such as a 4-4-5 weeks’ calendar, you need to write your…  Read more