DAX Patterns: Semi-additive calculations

These are in-depth video lectures of the Semi-additive calculations pattern.

Calculations reporting values at the start or the end of a time period require particular attention. These calculations do not work by aggregating values throughout the entire period, as you would typically do for sales amounts. Instead, the calculations should return the value at the beginning or the end of a selected time period. These calculations are also known as semi-additive calculations. They are semi-additive because they do sum up specific attributes, like customers, but not over other attributes, like dates, all the while reporting the value at the beginning or end of the period.

Students have access to a private discussion area where they can interact with the instructors asking questions related to the lectures and the exercises.


  • Semi-additive calculations

    • About the Semi-additive calculations pattern
    • Introduction
    • First and last date
    • First and last date with data
    • First and last date by customer
    • Opening and closing balance
    • Growth in period


This content is also available in the collection:
DAX Patterns collection