How to show data for last 4 weeks based on selected week in slicer?

[NebojsaZ88]

Hi,

I am currently stucked trying to figure out how to show in table data for previous 4 weeks based on selected week in slicer? Ideally, if it is selected current week (2022-11-26 - I am showing as Week Ending), to have in Rows only weeks for current month, meaning:

2022-11-19

2022-11-12

2022-11-05

In my Calendar table, I have columns:

1) Week Ending, [Date]-MOD([Date]-1,7)+6 

2) This Week Slicer = if( value(YEAR (NOW() ) & 100 + WEEKNUM (NOW() )) = value(('Calendar'[Week Year Number])), "This Week",FORMAT('Calendar'[Week Ending],"YYYY-MM-DD")) - I am using this one for slicer where "This Week" represent current week (in my case 2022-11-26)

3) Last Week Ending = DATEADD('Calendar'[Week Ending],-7,DAY) - I am using this one for table to show always data for previous week based on week selected in slicer.

...but how to show 4 previous weeks instead of only one? Why slicer does not alow me to show list of all previous weeks, instead of only one?

[NebojsaZ88]

Never mind. I fould solution. Thanks anyhow.

[Ptripath]

Could you please share the solution we need to implement same.

[lbendlin]

Weeks and Months are not compatible. Please provide a more detailed explanation of what you are aiming to achieve. What have you tried and where are you stuck?