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:
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 - 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/
Answer is correct
Not quite, the last closing bracket should be at the end.
Answer is correct.
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.
TotalYTD; 'Date'[date]
Why can't we use LASTDATE instead of date ?
because the requirement is the sum of Total Sales for a year up to a selected date.
So including the most recent year in the data right?
So including the most recent year in the data right?
Answer is Correct!
Answer is correct
Answer is correct
Correct! Could Be: CALCULATE( [Total Revenue], TOTALYTD('Date'[Date]) )
Answer is correct TOTALYTD, 'Date'[Date]
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.
can someone explain why can't we use SUM function?
it already using the measure
SUM is syntactically incorrect, it requires just one column. SUM(<Column>)
Answer is correct.