Forum Discussion

rickylee's avatar
rickylee
Helper III
8 years ago

SAMEPERIODLASTYEAR does not work as expected

Hello, I am trying to use the SAMEPERIODLASTYEAR formula but it seems it does not work as it is.  Last year revenue2a = CALCULATE(sum('Revenue 2017 18'[Total]),SAMEPERIODLASTYEAR('Calendar'[Date]...