I wanted Records 52 Weeks prior Till Current Date in a table when a Week is selected [Dates are in Weekly Basis, only 1 Date for a single Week i.e. Monday].
For example :
When 25th Jan 2021 is selected, the Data Must appear from 27th Jan 2020 To 25th Jan 2021 in the Table Measure.
But however, the below date, which is 7 Days Prior (18th Jan 2021), should also have the information from 20th Jan 2020 To 18th Jan 2021.
I have Prepared A table for Better Understanding
Week
Value
25th - Jan - 2021
From 27th - Jan - 2020 To 25th - Jan - 2021
18th - Jan - 2021
From 20th - Jan - 2020 To 18th - Jan - 2021
11th - Jan - 2021
From 13th - Jan - 2020 To 11th - Jan - 2021
And So on with the Dates Decreasing in 7 Day Format.
(This when 25th - Jan - 2021 is selected.). If Prior Dates are selected, the Table should adjust accordingly.
If anyone can help me with this, I'll be really grateful.
