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
danzrust's avatar
danzrust
Helper IV
9 years ago

-7 would give you 1 day only... No?

 

I need to do last 7 days vs last 8-14 days...

 

DZ

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi danzrust

 

I'm here to help you!

 

Try this measure out:

 

Sum of Value this week = CALCULATE(SUM(TABLE[Value]);DATESINPERIOD(TABLE[Date];LASTDATE(TABLE[Date];-7;DAY)

 

Sum of Value last week = CALCULATE([Sum of Value this week];DATEADD(TABLE[Date];-7;DAY)

 

Sum of Value this week - Sum of Value last week = [Sum of Value this week] - [Sum of Value last week]

 

Let me know if this works out. If you need further help, could you possibly provide some test data, whichs simulates your data?

 

Best,

Martin

  • danzrust's avatar
    danzrust
    Helper IV
    9 years ago

    Anonymous:
    Your measures are not "sophisticated enough". I need WoW measure to work with last 7D and last 8-14D from any ANY date

     

    Basically, I need this:

     

    I needs to work exactly like the MoM formula in the first post, the only change is the last 7 days vs last 8-14 days instead of months.

    • danzrust's avatar
      danzrust
      Helper IV
      9 years ago

      Anyone?

      • 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