Question 25 of 388
Single answerYou have a sales system that contains the tables shown in the following table.The Date table is marked as a date table. DateID is the date data type.You need to create an annual sales growth percentage measure.Which DAX expression should you use?
ASUM(sales[sales_amount]) - CALCULATE(SUM(sales[sales_amount]), SAMEPERIODLASTYEAR('Date'[DatelD])
BCALCULATE(SUM(sales[sales_amount]), DATESYTD('Date'[DatelD]))
✓C(SUN(sales[sales_amount]) - CALCULATE(SUM(sales[sales_amount]), SAHEPERIOOLASTYEAR('Date'[DatelD]))/ CALCULATE(SUM(sales[sales_amount]), SAMEPERIOOLASTYEAR ('Date'[DateID])
DCALCULATE(SUH(sales[sales_amount]), SAMEPERIODLASTYEAR('Date'[DatelD])
✓
Correct Answer: C
(SUN(sales[sales_amount]) - CALCULATE(SUM(sales[sales_amount]), SAHEPERIOOLASTYEAR('Date'[DatelD]))/ CALCULATE(SUM(sales[sales_amount]), SAMEPERIOOLASTYEAR ('Date'[DateID])
▥
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.