Posts: 1
Registered: ‎01-27-2017

Lab 2 LY calculations

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

Posts: 56
Registered: ‎03-10-2016

Re: Lab 2 LY calculations

Could you provide error message?

DN Frequent Visitor
Frequent Visitor
Posts: 12
Registered: ‎11-21-2016

Re: Lab 2 LY calculations

me too, I dont understand this difference. why do I need to use date from Date Table and cannot use date form Sales Table?
what kind of filters happen over this?