Warning: Undefined variable $in_footer in /var/www/html/exam4training.com/wp-content/themes/ultra-child/functions.php on line 14
Which DAX expression should you use? - Exam4Training

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'[DateID])
B . (SUM(‘Sales’[sales_amount]) – CALCULATE(SUM(‘Sales’[sales_amount]), SAMEPERIODLASTYEAR(‘Date’[DateID])))
/ CALCULATE(SUM(‘Sales’[sales_amount]), SAMEPERIODLASTYEAR(‘Date’[DateID]))

C . CALCULATE(SUM(sales[sales_amount]), DATESYTD(‘Date’[DateID]))
D . CALCULATE(SUM(sales[sales_amount]), SAMEPERIODLASTYEAR(‘Date’[DateID]))

Answer: B

Explanation:

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.

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

Latest PL-300 Dumps Valid Version with 131 Q&As

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

Leave a Reply

Your email address will not be published.

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>