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
Students have access to a private discussion area where they can interact with the instructors asking questions related to the lectures and the exercises.
- About the Like-for-like comparison pattern
- Pattern description