Forum Discussion

danzrust's avatar
danzrust
Helper IV
9 years ago

Week Over Week Calculations

Hi guys, There are few similar topics on this forum, but I have a feeling the all of them are trying to solve slighly different scenarios.   I am playing with MoM and WoW calculations.   I was a...
Need Help
Vvelarde's avatar
Vvelarde
Community Champion
8 years ago

danzrust

 

hi, try with this:

WoW =
VAR Week1 =
    CALCULATE (
        SUM ( Table1[Sales] ),
        DATESINPERIOD ( Table1[Today], SELECTEDVALUE ( Table1[Today] ) - 1; -7, DAY )
    )
VAR Week2 =
    CALCULATE (
        SUM ( Table1[Sales] ),
        DATESINPERIOD ( Table1[Today], SELECTEDVALUE ( Table1[Today] ) - 8; -7, DAY )
    )
RETURN
    DIVIDE ( Week1, Week2 ) - 1

regards

 

Victor

Lima . Peru

danzrust's avatar
danzrust
Helper IV
8 years ago

Figured it out myself long time ago.

 

I am using custom calendar table. For absolute diff, this is the formula:

Clicks WoW Abs = (
SUMX(FILTER('AdWords KW Data L2W', RELATED('Calendar'[Last X Weeks])="Last Week-00"),'AdWords KW Data L2W'[Clicks])
-
SUMX(FILTER('AdWords KW Data L2W', RELATED('Calendar'[Last X Weeks])="Last Week-01"),'AdWords KW Data L2W'[Clicks])
)

 

The calendar is here:

https://docs.google.com/spreadsheets/d/1-55vUYZrYKduI8tbuK5nk9GXBUc7X7uNMcS1mXRIdoI/edit?usp=sharing

 

Import link for PBI (free to use):
https://docs.google.com/spreadsheets/d/1-55vUYZrYKduI8tbuK5nk9GXBUc7X7uNMcS1mXRIdoI/export?format=csv&id=1-55vUYZrYKduI8tbuK5nk9GXBUc7X7uNMcS1mXRIdoI&gid=0

 

DZ