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

delavi's avatar
delavi
Frequent Visitor
8 years ago

This is almost  perfect for me.  Made a couple small changes due to the way PBI counts days - otherwise this is awesome!

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

@Vvelarde