Forum Discussion
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 ...
I finally found my problem, i didn't mark PBI table as date table.
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
Thanks for your answer, but my slicer is from my 'PBI date' table
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
I finally found my problem, i didn't mark PBI table as date table.