Question 370 of 388
Single answerYou 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?
✓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 ) )
✓
Correct Answer: A
CALCULATE ( [Total Sales], DATEADD (Date[Date], -1, QUARTER ) )
▥
Explanation
The correct answer is highlighted above. Review the wording carefully, then use the next question to continue building your understanding of Microsoft certification topics.