I have this sales and date table below and I was wondering if it would be possible to create a measure that shows me the total sales for the last week but only for the same amount of days. So for example we are in day 3 this week and i'd like to see the sales for the same 3 days last week if that makes sense. I'm able to do it for month because there are actual month related formulas in power bi but there is nothing for week as far as i'm aware.
| Date | Week | Revenue |
| 29/11/2020 | 49 | 5,000 |
| 30/11/2020 | 49 | 6,000 |
| 01/12/2020 | 49 | 3,000 |
| 02/12/2020 | 49 | 2,000 |
| 03/12/2020 | 49 | 6,000 |
| 04/12/2020 | 49 | 1,000 |
| 05/12/2020 | 49 | 1,000 |
| 06/12/2020 | 50 | 1,000 |
| 07/12/2020 | 50 | 2,000 |
| 08/12/2020 | 50 | 3,000 |
| 09/12/2020 | 50 | 4,000 |
| 10/12/2020 | 50 | 5,000 |
| 11/12/2020 | 50 | 6,000 |
| 12/12/2020 | 50 | 7,000 |
| 13/12/2020 | 51 | 7,000 |
| 14/12/2020 | 51 | 7,000 |
| 15/12/2020 | 51 | 7,000 |
What I'd like it to look like is this:
| Week | Revenue | Revenue Same period last week |
| 50 | 28,000 | 24,000 |
| 51 | 21,000 | 6,000 |
