01-27-2017 06:59 AM
I got this one wrong because I used LY Sales = CALCULATE([Total Sales],SAMEPERIODLASTYEAR(Sales[Date])) instead of LY Sales = CALCULATE([Total Sales],SAMEPERIODLASTYEAR('Date'[Date]))
What exactly is the difference between these 2 please?
Many thanks, all
03-03-2017 08:46 PM - edited 03-03-2017 09:09 PM
Could you please provide an explanation? I got this wrong, also. Even after entering the DEX expressions from the Explanation (the answer...)
It is rediculous to plug in values from the "Answer", and still get an ncorrect value.
And no, I did not receive an error, just a Sales Var % of 0.03%.
EDIT: Nevermind, I found the answer in another post, where it mentioned that the data type for Sales Var % simply needed to be of type Percentage. Sheesh... It was not even intuative how to change the value type
03-05-2017 11:27 PM
I also found the issue, if use Date type of Sales, the result about 0.03%. but if use Date type of Date table, the result is different, I think that the question's answer dependence on Instrcutor's demo in video, so if you want to get correct result, you can use the tip at the bottom of page