Forum Discussion
Solved
Rolling 8 weeks values on the visual
I need to display a rolling 8-week period in my visual. I'm currently using the Relative Date filter. When I refresh the visual during the current week, it includes the current partial week (for exam...
Hi VJ_Lsf
If you choose "calendar weeks" instead of "weeks", the filter will include the last 8 complete Sun-Sat weeks.
If that's not the definition you want, you could add a Week Offset column that updates on each refresh based on the current date, then apply a filter such as Week Offset ≥ -8 and Week Offset ≤ -1.
Do either of the above help in your case?
Hi VJ_Lsf
If you choose "calendar weeks" instead of "weeks", the filter will include the last 8 complete Sun-Sat weeks.
If that's not the definition you want, you could add a Week Offset column that updates on each refresh based on the current date, then apply a filter such as Week Offset ≥ -8 and Week Offset ≤ -1.
Do either of the above help in your case?
