Calculating Rolling Week over Week (last 7 days vs. previous 7 days)

[majerde]

Hello,

I am trying to calculate WoW, using the last 7 days vs. previous 7 days as a % change. I can get the last 7 day sum, but how can I get the previous 7 days (so days 8-14) to calculate the below?

(Sum of last 7 days - sum of previous 7 days)/sum of previous 7 day

Thanks!

[majerde]

Worked like a charm! Thank you @DOLEARY85!

[DOLEARY85 · Accepted solution]

Hi,

try this for days the previous 7 days (8 - 14) :

Days 8 - 14 = CALCULATE (

SUM ( 'Table (2)'[amount] ),

DATESINPERIOD ( 'Table (2)'[date],LASTDATE('Table (2)'[date] )-7, -14, DAY )

)

overall calc:

Overall = CALCULATE(CALCULATE (

SUM ( 'Table (2)'[amount] ),

DATESINPERIOD ( 'Table (2)'[date] ,LASTDATE('Table (2)'[date] ), -7, DAY )

) - CALCULATE (

SUM ( 'Table (2)'[amount] ),

DATESINPERIOD ( 'Table (2)'[date],LASTDATE('Table (2)'[date] )-7, -14, DAY )

))/CALCULATE (

SUM ( 'Table (2)'[amount] ),

DATESINPERIOD ( 'Table (2)'[date] ,LASTDATE('Table (2)'[date] ), -7, DAY )

)

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍