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.

Students have access to a private discussion area where they can interact with the instructors asking questions related to the lectures and the exercises.


  • 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

Training Platform

This course is conducted through our training platform which is immersive and designed to facilitate your experience.

Discover all the features