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

Collection

This content is also available in the collection:
DAX Patterns collection
Student Rating
4.6
9 ratings
78%
11%
0%
11%
0%
5-star Reviews (2 of 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.