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
Anonymous's avatar
Anonymous
Not applicable
9 years ago

Why not use DATEADD with DAY and -7?

  • 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.