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 primary goal of creating a DAX measure in this tutorial?

• To list all customers alphabetically

• To identify recurring customers

• To calculate total sales for all customers

• To find the highest spending customer

Which keyword is used to define a variable in DAX?

• LET

• SET

• DEF

• VAR

What function is used to return a unique list of values from a column?

• UNIQUE

• LIST

• DISTINCT

• VALUES

Which function is used to adjust the filter context by shifting dates?

• DATEDIFF

• DATEFORMAT

• DATEPART

• DATEADD

What is the purpose of the INTERSECT function in this context?

• To combine two tables into one

• To find common rows between two tables

• To sort the rows of a table

• To subtract one table from another

How can you display the sum of sales for both the current and previous year?

• By using the AVERAGE function

• By using the SUM function

• By creating a new measure for each year

• By adding total sales and total sales last year

What adjustment is made to the formula to show sales for both years?

• Dividing total sales by the number of years

• Adding total sales and total sales last year

• Multiplying total sales by two

• Subtracting total sales last year from total sales