Forum Discussion

hiran's avatar
hiran
Icon for Helper I rankHelper I
5 years ago
Solved

Same period last week

 
Hello,

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.

DateWeekRevenue
29/11/2020495,000
30/11/2020496,000
01/12/2020493,000
02/12/2020492,000
03/12/2020496,000
04/12/2020491,000
05/12/2020491,000
06/12/2020501,000
07/12/2020502,000
08/12/2020503,000
09/12/2020504,000
10/12/2020505,000
11/12/2020506,000
12/12/2020507,000
13/12/2020517,000
14/12/2020517,000
15/12/2020517,000

 

What I'd like it to look like is this:

WeekRevenueRevenue Same period last week
5028,00024,000
5121,0006,000
 
Need Help

3 Replies