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

Thank you for answering so quickly. 

 

W

hen I select no YEAR from the Slicer, it works just perfectly, but when a YEAR is selected, the LY values are blank  

Below you can see a screenshot of the Date table : 

 

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Is the year date slicer also using the fulldatealternatekey column?
  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    For the Slicer I used :

    Year = YEAR('Date'[FullDateAlternateKey])

    Now that  I replace the slicer with FullDateAlternateKey, it is working perfectly. 

     

    But why ??:smileyfrustrated:

    • 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: