Forum Discussion
SAMEPERIODLASTYEAR returns bank
Hello all, I am working on the AdventureWorks tables and trying to create a Sale Performance report. I have these three measures: Total Sale = SUMX(InternetSales, InternetSales[OrderQuantity...
Hi
It's because your Slicer is using a calculated column and your measure for Same period last year is using another column.
The sameperiodlastyear function must use the same column that you are filtering with your slicer.
Yes, now I understand what the problem is.
Thank you for the explanation.
I just wanted to have 'year' separately, and by using YEAR(date) function, the return value is an integer which can not be used in the SAMEPERIODLASTYEAR function.
The only option that I have( or I can think of) is to add a calendar to my slicer like below:
