In my data set I have a Start Date and End Date. I'd like to create a week of filter for all weeks within the range of those dates.
For example, my Start Date is 7/3 and End Date is 7/30 (4 weeks). I'd like to create a field that lets me choose a week of between that range (e.g. 7/3, 7/10, 7/17, 7/24).
In the attached, filtering for Week of 7/10 would filter out row 3 (7/3 - 7/9).
Thanks in advance for any ideas.
I think your question may be similar to the one answered here:
In your case, you would need to join to a lookup table with all the possible week start and week end dates.