Forum Discussion
rickylee
Helper III
Helper IIISAMEPERIODLASTYEAR 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]...
v-danhe-msft
Microsoft Employee
Microsoft EmployeeHi rickylee,
Based on my test, this is due to your calendar table contains the date in 2019, you could modify your calendar table like this:
Table = CALENDAR("2017/1/1","2018/12/31")And now you could get the correct result:
You can also download the PBIX file to have a view.
Regards,
Daniel He