Forum Discussion

rickylee's avatar
rickylee
Icon for Helper III rankHelper 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
v-danhe-msft's avatar
v-danhe-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi rickylee,

Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered?

 

Regards,

Daniel He