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

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.