DA-100 Exam Dumps | You have a sales system that contains the tables shown in the following table. (Exhibit) The Date table

<< Prev Question Next Question >>

Question 16/42

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. (SUN(sales[sales_araount]) - CALCULATE(SUM(sales[sales_amount]), SAHEPERIOOLASTYEAR('Date'[DatelD]))/ CALCULATE(SUM(sales[sales_amount]), SAMEPERIOOLASTYEAR ('Date'[DateID])

B. SUM(sales[sales_amount]) - CALCULATE(SUM(sales[sales_amount]), SAMEPERIODLASTYEAR('Date'[DatelD])

C. CALCULATE(SUH(sales[sales_araount]), SAMEPERIODLASTYEAR('Date'[DatelD])

D. CALCULATE(SUM(sales[sales_amount]), DATESYTD('Date'[DatelD]))

Question 16/42

LEAVE A REPLY

Download PDF File