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.
For the Slicer I used :
Year = YEAR('Date'[FullDateAlternateKey])Now that I replace the slicer with FullDateAlternateKey, it is working perfectly.
But why ??:smileyfrustrated:
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.