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
Percentage required so C is correct