Week-to-Date And SPLY Calendar Table Filter

[Anonymous]

Hello 

I am just trying to create the above Date Calendar filter so I can just graphically show as below Week on Week Year to Date compared to Same Period as Last Year without having to manually filter the weeks inbetween last year and this year and also without having to create seprate measurements. Any ideas?

 

[v-sihou-msft · Accepted solution]

@Anonymous

I can't see your Calendar Slicer. Do you want to dynamically get two years in your chart if you only select one year in slicer?

When you select one year in slicer, the table context is limited to that year only, it's not possible to directly select two years into your chart. And you can't create a dynamic calcualted table either.

In this scenario, you need to add a column into your table for tagging if it's within last year. Then you can select this tag in slicer to get correspond dates. Please also refer to a similar thread below:

https://community.powerbi.com/t5/Desktop/Last-12-months/m-p/85704#M35944

Regards,