DAX Patterns: Like-for-like comparison

These are in-depth video lectures of the Like-for-like comparison pattern.

The like-for-like sales comparison is an adjusted metric that compares two time periods, restricting the comparison to products or stores with the same characteristics. For example, you can compare the sales of stores that had sales in all the time periods considered. The stores are continuously updated: new stores are opened, other stores are closed or renovated. The like-for-like comparison only evaluates those stores that were open in all the periods considered. This way, the report does not show a store

Collapse allCurriculum

  • Like-for-like comparison

    • About the Like-for-like comparison pattern
    • Introduction
    • Pattern description


This content is also available in the collection:
DAX Patterns collection
Student Rating
2 ratings