PL-300 · Question #370
PL-300 Question #370: Real Exam Question with Answer & Explanation
Sign in or unlock PL-300 to reveal the answer and full explanation for question #370. The question stem and answer options stay visible for context.
Question
You have a Power BI model that contains the following data. The Date table relates to the Sales table by using the Date columns. The model contains the following DAX measure. Total Sales = SUM(Sales[Sale]) You need to create another measure named Previous Quarter to display the sales one quarter before the selected period. Which DAX calculation should you use?
Options
- ACALCULATE ( [Total Sales], DATEADD (Date[Date], -1, QUARTER ) )
- BCALCULATE ( [Total Sales], DATESQTD (Date[Date] ) )
- CTOTALQTD ( [Total Sales], Date[Date] )
- DCALCULATE ( [Total Sales], PARALLELPERIOD (Date[Date], 1, QUARTER ) )
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.