You have the Power BI data model shown in the following exhibit.
 
The Sales table contains records of sales by day from the last five years up until today’s date.
You plan to create a measure to return the total sales of March 2021 when March 2022 is selected.
Which DAX expression should you use?

A. Calculate (Sum(Sales[Sales]), PREVIOUSYEAR( dimDate[Date])

B. TOTALYTD (SUM(Sales[Sales]), dimDate[Date] )

C. Calculate (SUM(Sales[Sales]), SAMEPERIODLASTYEAR(dimDate[Date] ))

D. SUM(Sales[Sales])








 

Suggested Answer: C



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.