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?

A. CALCULATE ( [Total Sales], DATEADD (Date[Date], -1, QUARTER ) )

B. CALCULATE ( [Total Sales], DATESQTD (Date[Date] ) )

C. TOTALQTD ( [Total Sales], Date[Date] )

D. CALCULATE ( [Total Sales], PARALLELPERIOD (Date[Date], 1, QUARTER ) )








 

Suggested Answer: A



This question is in PL-300 Microsoft Power BI Data Analyst Exam
For getting Microsoft Certified: Power BI Data Analyst Associate Certificate







Disclaimers:
The website is not related to, affiliated with, endorsed or authorized by Microsoft. 
The website does not contain actual questions and answers from Microsoft's Certification Exams.
Trademarks, certification & product names are used for reference only and belong to Microsoft.