Backward summation

joslaz

Board Regular
Joined
May 24, 2018
Messages
71
Hello everybody!

How can I summarize my data backwards?
For Example:
Month November (actual Month): All Values for November
Month October (actual Month -1): All Values for October and November
....

The table has the follwing structure:
ArticleDateValue
A01.11.20195000
A01.10.20192500


How would you manage that with a dax measure?

Best Regards
 

Rijnsent

Well-known Member
Joined
Oct 17, 2005
Messages
1,116
Office Version
365
Platform
Windows
Hi Joslaz,
with a normal formula I would use a SUMIFS. Something like: =SUMIFS(Values,Dates>=Date,Articles=Article). Does that make sense?
Koen
 

Forum statistics

Threads
1,078,077
Messages
5,338,059
Members
399,201
Latest member
PCMK99

Some videos you may like

This Week's Hot Topics

Top