Forum Discussion

Blucas2018's avatar
Blucas2018
Regular Visitor
8 years ago

SAMEPERIODLASTYEAR not working for old database

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

 

 

 

 

1 Reply

  • Floriankx's avatar
    Floriankx
    Solution Sage
    8 years ago

    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.