Which DAX expression should you use?

You have a sales system that contains the tables shown in the following table.

The Date table is marked as a date table.

DatelD is the date data type. You need to create an annual sales growth percentage measure.

Which DAX expression should you use?
A . SUM(sales[sales_amount]) – CALCULATE(SUM(sales[sales_amount]), SAMEPERIODLASTYEAR(‘Date'[DatelD])
B . CALCULATE(SUM(sales[sales_amount]), DATESYTD(‘Date'[DatelD]))
C . (SUN(sales[sales_araount]) – CALCULATE(SUM(sales[sales_amount]), SAHEPERIOOLASTYEAR(‘Date'[DatelD]))/ CALCULATE(SUM(sales[sales_amount]), SAMEPERIOOLASTYEAR
(‘Date'[DateID])
D . CALCULATE(SUH(sales[sales_araount]), SAMEPERIODLASTYEAR(‘Date'[DatelD])

Answer: D

Latest DA-100 Dumps Valid Version with 114 Q&As

Latest And Valid Q&A | Instant Download | Once Fail, Full Refund

Subscribe
Notify of
guest
1 Comment
Inline Feedbacks
View all comments
imtiaz.hasan
imtiaz.hasan
3 years ago

Percentage required so C is correct