DAX Patterns: Transition matrix

These are in-depth video lectures of the Transition matrix pattern.

This pattern analyzes changes in an attribute assigned to an entity at regular intervals. For example, customers might receive a ranking evaluation every month, or products might have a rating score measured every week. Measuring the changes in rating between two points in time might require the evaluation of how many items moved from one rating to another within the considered interval. The transition matrix enables the end user to make this kind of analysis by just manipulating filters in a report and without having to write any custom query.

Collapse allCurriculum

  • Transition matrix

    • About the Transition matrix pattern
    • Introduction
    • Static transition matrix
    • Dynamic transition matrix


This content is also available in the collection:
DAX Patterns collection
Student Rating
5 ratings
5-star Reviews (2 of 2)
  • carlos barboza (Mar 28, 2024)

    Deep and advanced! Grazzie mille Marco and Alberto! grazie mille!!!

  • Genadiy Tsvetkov (Jan 2, 2024)

    Fantastic! Awesome analytical pattern! thanks guys!