Reverse/ cumulative running total

[joshua1990]

Hello everyone,

I am looking for a function that sums up reverse the values - from today to past.

I have a table like that:

Article	Value	Date
01	500	01.01.2019
01	250	02.01.2019
01	500	03.01.2019

In the end the result should be something like that:

Date	Value
01.01.2019	1250
02.01.2019	750
03.01.2019	500

How would you do that?

This function is not working:

=VAR currentDate = 'Calendar'[Date]
RETURN
CALCULATE (
SUM ( 'Item'[Value] );
FILTER ( ALL ( 'Calendar' ); 'Calendar'[Date]>= currentDate )
)

Best Regards

Joshua

[az38]

Hi @joshua1990 

try

Measure = calculate(SUM('Calendar'[Value]);FILTER(ALL('Calendar');'Calendar'[Date]>=selectedvalue('Calendar'[Date])))

do not hesitate to give a kudo to useful posts and mark solutions as solution

[joshua1990]

Thanks!

is there any chance to do this without SELECTEDVALUE?

[Anonymous]

@joshua1990 Replace selectedvalue with MAX.

[mfed]

Solution works well, thank you - noticed that it doesn't matter if I have MAX or MIN in place of 'selectedvalue', can't figure out why - any clarification would be helpful...