DAX Patterns: New and returning customers

These are in-depth video lectures of the New and returning customers pattern.

This pattern helps in understanding how many customers in a period are new, returning, lost, or recovered. There are several variations to this pattern, each with different performance and results depending on the requirements. Moreover, it is a very flexible pattern that allows the identification of new and returning customers, or the computation of these customers’ purchase volume – also known as sales amount.


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

Curriculum

  • New and returning customers

    • About the New and returning customers pattern
    • Introduction
    • Pattern description
  • Dynamic relative pattern

    • Internal measures
    • New, lost, and returning customers
    • Recovered customers
  • Dynamic absolute pattern

    • Internal measures
    • New, lost, and returning customers
    • Recovered customers
  • Dynamic by category pattern

    • Internal measures
    • New, lost, and returning customers
    • Recovered customers
  • Snapshot absolute pattern

    • Snapshot pattern
    • Creating the derived snapshot table

Collection

This content is also available in the collection:
DAX Patterns collection