Microsoft Exam DA-100 Topic 7 Question 42 Discussion

Actual exam question for Microsoft's DA-100 exam

Question #: 42
Topic #: 7

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?

ASUM(sales[sales_amount]) - CALCULATE(SUM(sales[sales_amount]), SAMEPERIODLASTYEAR('Date'[DateID])

B(SUM('Sales'[sales_amount]) - CALCULATE(SUM('Sales'[sales_amount]), SAMEPERIODLASTYEAR('Date'[DateID])))
/ CALCULATE(SUM('Sales'[sales_amount]), SAMEPERIODLASTYEAR('Date'[DateID]))

CCALCULATE(SUM(sales[sales_amount]), DATESYTD('Date'[DateID]))

DCALCULATE(SUM(sales[sales_amount]), SAMEPERIODLASTYEAR('Date'[DateID]))

Show Suggested Answer

Suggested Answer: B

SAMEPERIODLASTYEAR returns a table that contains a column of dates shifted one year back in time from the dates in the specified dates column, in the current context.

https://docs.microsoft.com/en-us/dax/sameperiodlastyear-function-dax

by Whitley at May 10, 2022, 03:23 AM

Limited Time Offer

25%

Off

Get Premium DA-100 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!