Exam DA-100 topic 4 question 6 discussion

The answer is correct. CALCULATE and DATEBETWEEN

Shouldn't there be a SUM before Sales[Sales] ?

Answer Calculate Datesbetween

correct answer : CALCULATE and DATEBETWEEN. The first argument of calculate Sales[sales] it might be a measure that's why it does not need a function for the first argument.

7/11/22 was on exam calculate and datebetween

In exam 30/12/21

Could someone explain why sameperiod won't work?

Had this question on today’s exam 18 Oct, Question been modified to three answers

Calculate and datebetween Because they already calculated the corresponding date of last year

VAR startyear = STARTOFYEAR ( ‘Calendar'[Date] ) – 365 VAR enddate = LASTDATE ( Sales[Date] ) – 365 RETURN CALCULATE ( SUM ( Sales[sales] ), DATESBETWEEN ( ‘Calendar'[Date], startyear, enddate ) )

Based on the options provided, it has to be CALCULATE and DATESBETWEEN. The DAX syntax is a bit confusing here because 'Sales'[Sales] looks like a fully qualified column reference but it could also be a measure reference. I assume that it's a measure reference because the SUM function alone doesn't allow other arguments beyond the column reference, so we wouldn't even have to ability to add in additional parameters or functions. Using CALCULATE with the measure reference ('Sales'[Sales]) then allows you to modify the calculation in a filter context with DATESBETWEEN the date range between the two variables.

Sum and Datebetween

There must be a sum function to calculate the total sales. CALCULATE( sum(sales), datesbetween(start, end))

it should be calculate and sameperiolat year

I thank too

answer is wrong calculate , sameperiodlastyear , no specified period exist example: last year till today

Correct Answer