Forum Discussion

oupepasa's avatar
oupepasa
Frequent Visitor
5 years ago
Solved

Problem with sameperiodlastyear

I can't do a small table that gives me sales and last year sales by category,

 

here is the measure that stays empty each time i choose a filter, if i don't have any filter it's working, i have my sales till end of 2020

Last year Sales = 
VAR Val = CALCULATE(SUM('PBI Sales'[Sales price]), SAMEPERIODLASTYEAR('PBI Date'[Date]) )
VAR Result = if(ISBLANK(Val),0,Val)
RETURN     Result

 

Please help i feel so dumb right now i don't understand why it's not working .

 

 

here is the image of the table , i'm not always easy to understand , that may help

https://ibb.co/WP4M7gL

 

 

Need Help
  • oupepasa's avatar
    oupepasa
    5 years ago

    I finally found my problem, i didn't mark PBI table as date table.

5 Replies

  • BA_Pete's avatar
    BA_Pete
    Super User
    5 years ago

    Hi oupepasa ,

     

    Is your page slicer using [Year] from your 'PBI Date' table, or from your fact table? If it's from your fact table, then you need to switch it to 'PBI Date'[Year] as it may be an issue with relationship filters not being able to be passed from the fact table to the date table due to filter direction.

     

    Pete

    • oupepasa's avatar
      oupepasa
      Frequent Visitor
      5 years ago

      Thanks for your answer, but my slicer is from my 'PBI date' table

      • BA_Pete's avatar
        BA_Pete
        Super User
        5 years ago

        oupepasa ,

         

        Ok. Are you able to share an example of your data and a picture of the relevant parts of your data model please?

         

        If so, make sure to remove any sensitive information from the data sample.

         

        Thanks,

         

        Pete