Exam PL-300 topic 2 question 43 discussion

Actual exam question from Microsoft's PL-300

Question #: 43
Topic #: 2

HOTSPOT -
You have a Power BI report that contains a measure named Total Sales.
You need to create a new measure that will return the sum of Total Sales for a year up to a selected date.
How should you complete the DAX expression? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:

Show Suggested Answer

Suggested Answer:

Box 1: TOTALYTD -
TOTALYTD evaluates the specified expression over the interval which begins on the first day of the year and ends with the last date in the specified date column after applying specified filters.
Syntax: TOTALYTD (
<Expression>,
<Dates>
[, <Filter>]
[, <YearEndDate>]
Expression - The expression to be evaluated.
Dates - The name of a column containing dates or a one column table containing dates.
Example:
TOTALYTD ( -- 2007-01-01 : 2007-05-12
[Sales Amount],
'Date'[Date]
Box 2: 'Date'[Date]
Reference:
https://dax.guide/totalytd/

by lukelin08 at Oct. 7, 2022, 4:38 a.m.

Comments

Submit Cancel

lukelin08

Highly Voted 2 years, 9 months ago

Answer is correct

upvoted 51 times

LeeTheRed

1 year, 7 months ago

Not quite, the last closing bracket should be at the end.

upvoted 2 times

...

Orkhannnn

Highly Voted 2 years, 8 months ago

Answer is correct.

upvoted 15 times

...

jaume

Most Recent 7 months, 4 weeks ago

Position of the second parenthesis (closin parenthesis) IN FRONT of the second argument is totally misleading; since TOTALYTD function requires two mandatory arguments, you can assume this is an error and this parenthesis should be AFTER the second argument.... TOTALYTD and Date[Date] should work in this scenario.

upvoted 2 times

...

rcaliandro

11 months ago

Answer is correct TOTALYTD, 'Date'[Date]

upvoted 2 times

...

JudT

1 year, 3 months ago

Correct! Could Be: CALCULATE( [Total Revenue], TOTALYTD('Date'[Date]) )

upvoted 2 times

...

Igetmyrole

1 year, 10 months ago

TOTALYTD `Date`[Date] TOTALYTD: is being used to calculate the sum of "Total Sales" year-to-date up to the selected date. `Date`[Date]: provides the date context for the calculation.

upvoted 12 times

...