Problem with sameperiodlastyear

[oupepasa]

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

[BA_Pete]

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]

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

[BA_Pete]

@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

[oupepasa]

here is a picture of the table i use here

https://ibb.co/cwhgQzk

[oupepasa · Accepted solution]

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