How to sum values from previous lines?

[ZoltanFut]

Hi guys,

I’ve a following problem:

There’s a table with the following columns:

Date	Value
2018.06.25	12
2018.06.26	12
2018.06.27	12
2018.06.28	4
2018.06.28	8
2018.06.29	1
2018.06.29	8

How can I add a column, that sums the values by the actual date in the row, like this?

Date	Value	SumValue
2018.06.25	12	12
2018.06.26	12	24
2018.06.27	12	36
2018.06.28	4	40
2018.06.28	8	48
2018.06.29	1	49
2018.06.29	8	57

Thanks for your suggestions in advance!

Zoltán

[AlB · Accepted solution]

Hi @ZoltanFut

Try this for your new column. Note that this will yield the same result for all rows with the same date, since I see there are duplicates.

CumulativeSumValue =
CALCULATE (
    SUM ( Table1[Value] ),
    FILTER ( Table1, Table1[Date] <= EARLIER ( Table1[Date] ) )
)

[ZoltanFut]

Hi AlB,

thanks for the solution, and the idea, I can work toward on this  🙂

thanks

Zoltán