Hello I’m after a formula for Power Bi, I have a column called “Removal Date”, this contains dates from 1 Jan 2018 to 1 Jan 2022, I want to show in a table all date records which are last week to 6 weeks in the future.
So if this week is 37, then I want to show week 36 to 43 data.
Next week it will be week 38 so I want to show week 37 to 44.
Also when it gets to week 51, it needs to show week 50 (2019) to week 5 (2020)
Could you write me a formula for this
I will share more data if you want.
Please bid if you are located in US. (Prefer to live in FL)