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]...
Need Help
rickylee's avatar
rickylee
Helper III
8 years ago

v-danhe-msft

Hello, it does not work for me as such but  I manually created an alternative solution. It does not use the function which is not ideal.

Thanks,
Ricky