Question 271 of 388
Single answerYou have the Power BI data model shown in the following exhibit. 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?
ACalculate (Sum(Sales[Sales]), PREVIOUSYEAR( dimDate[Date])
BTOTALYTD (SUM(Sales[Sales]), dimDate[Date] )
✓CCalculate (SUM(Sales[Sales]), SAMEPERIODLASTYEAR(dimDate[Date] ))
DSUM(Sales[Sales])
✓
Correct Answer: C
Calculate (SUM(Sales[Sales]), SAMEPERIODLASTYEAR(dimDate[Date] ))
▥
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.