Power BI Masterclass - Advanced DAX - Recurring Customers and Their Sales Calculation

The video tutorial explains how to create a DAX measure to identify recurring customers, defined as those who ordered in both the current and previous year. It covers using variables to store customer data, adjusting date contexts with date functions, and calculating sales for recurring customers using the intersect function. The tutorial also demonstrates how to format and display customer data by year and create a measure to sum sales across multiple years. The video concludes with a summary and encourages viewers to explore further.

What is the definition of a recurring customer as described in the text?

Explain the process of creating a new measure for recurring customers.

What role do variables play in the calculation of recurring customers?

How does the 'date add' function contribute to the calculation of prior year sales?

Describe the significance of the filter context in the calculation of recurring customers.

How can you visualize the data for recurring customers over the years?

What adjustments are made to the total sales measure to account for both the current and prior year?