Forum Discussion
NebojsaZ88
3 years agoFrequent Visitor
How to show data for last 4 weeks based on selected week in slicer?
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?
3 Replies
- lbendlin
Super User
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?
- NebojsaZ88Frequent Visitor
Never mind. I fould solution. Thanks anyhow.
- PtripathNew Member
Could you please share the solution we need to implement same.