DAX Patterns: Comparing different time periods

These are in-depth video lectures of the Comparing different time periods pattern.

This pattern is a useful technique to compare the value of a measure in different time periods. For example, we can compare the sales of the last month against a user-defined period. The two time periods might have a different number of days, like comparing one month against a full year. When the durations of both time periods are different, we should adjust the values to make a fair comparison.

Collapse allCurriculum

  • Comparing different time periods

    • About the Comparing different time periods pattern
    • Introduction
    • Pattern description


This content is also available in the collection:
DAX Patterns collection
Student Rating
8 ratings
Student Reviews (3)
  • Matthew Snow (Mar 6, 2021)

    Really helpful description, I can see many sues for this pattern

  • carlos barboza (Feb 20, 2021)

    Very interesting pattern. I look forward to putting in practice.

  • Claudio Trombini (Feb 5, 2021)