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.

Collapse allCurriculum

  • 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
Student Rating
5 ratings
Student Reviews (1)
  • Cristian Angyal (Jul 7, 2021)

    This is pure gold for BI Developers: really good examples with VERY GOOD explanations. Thank you Marco and Alberto!