Backward summation

[joslaz]

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:

Article	Date	Value
A	01.11.2019	5000
A	01.10.2019	2500

How would you manage that with a dax measure?

Best Regards

 

[Rijnsent]

Hi Joslaz,
with a normal formula I would use a SUMIFS. Something like: =SUMIFS(Values,Dates>=Date,Articles=Article). Does that make sense?
Koen