Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

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

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 be...
Need Help
Tips and Tricks
  • DOLEARY85's avatar
    DOLEARY85
    3 years ago

    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 👍

DOLEARY85's avatar
DOLEARY85
Icon for Resident Rockstar rankResident Rockstar
3 years ago

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 👍