Forum Discussion
Relative Date Slicer
I am trying to apply a relative date filter to look at data four weeks in the future from todays date, but also include all data dated prior to today's date. I've created the relative date slicer, but I'm not sure how to include the old data as well. Any help or advice you can give me would be greatly appreciated. Thank you!
Hello Anonymous
If you add a column to your dates table that calculates the week offset (difference between the week of TODAY() and the week of the date on the row) you can set your filter to WeekOffset <= 4 and that will grab 4 weeks in the future and everything before that.
2 Replies
Hello Anonymous
If you add a column to your dates table that calculates the week offset (difference between the week of TODAY() and the week of the date on the row) you can set your filter to WeekOffset <= 4 and that will grab 4 weeks in the future and everything before that.
jdbuchanan71 That worked perfectly. Thank you for your help!