PL-300 · Question #406
You have a Power BI model that contains two tables named Sales and Date. The Sales table relates to the Date table by using a many-to-one relationship. The Sales table contains the following columns:
Sign in or unlock PL-300 to reveal the answer and full explanation for question #406. The question stem and answer options stay visible for context.
Question
You have a Power BI model that contains two tables named Sales and Date. The Sales table relates to the Date table by using a many-to-one relationship. The Sales table contains the following columns:
- Date
- Product
- SalesAmount
You need to create a DAX measure for a rolling 31-day sales total that will return the total sales amount for a selected date and the previous 30 days. Which DAX expression should you use?
Options
- ACALCULATE(SUM(Sales[SalesAmount]), DATEADD(Date[Date], -30, DAY))
- BCALCULATE(SUM(Sales[SalesAmount]), DATESBETWEEN(Date[Date], Max('Date'[Date])-30,
- CCALCULATE(SUM(Sales[SalesAmount]), DATESMTD(Date[Date]))
- DCALCULATE(SUM(Sales[SalesAmount]), DISTINCTCOUNT(Date[Date]) = 31)
Unlock PL-300 to see the answer
You've previewed enough free PL-300 questions. Unlock PL-300 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.