Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

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...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
8 years ago

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.

Anonymous's avatar
Anonymous
Not applicable
8 years ago

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: