SAMEPERIODLASTYEAR not working for old database

[Blucas2018]

Hi,

I'm going through this tutorial but I'm having trouble using SAMEPERIODLASTYEAR on a table where the latest date is from 3 years ago.

 The tutorial recommned using:

• Total Units: Total Units = SUM(Sales[Units])
• LY Total Units: LY Total Units = CALCULATE([Total Units],SAMEPERIODLASTYEAR('Date'[Date]

but I get the same value for both measures. Could that be SAMEPERIODLASTYEAR is looking for 2017, therefore counting everything like SUM?

The data goes from year 2000 to 2015

Any suggestions

[Floriankx]

Did you relate your date columns properly?

SAMEPERIODLASTYEAR doesn't know the actual year, and it doesn't how far your data goes back.

Is your date Table contigous and goes back far enough?

Best regards.