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?

Evaluate responses using AI:

OFF

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

Evaluate responses using AI:

OFF

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

Evaluate responses using AI:

OFF

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

Evaluate responses using AI:

OFF

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

Evaluate responses using AI:

OFF

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

Evaluate responses using AI:

OFF

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

Evaluate responses using AI:

OFF