Reply
Frequent Visitor
Posts: 2
Registered: ‎01-17-2019
Accepted Solution

How to sum values from previous lines?

 

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


Accepted Solutions
AlB Super Contributor
Super Contributor
Posts: 1,180
Registered: ‎11-12-2018

Re: How to sum values from previous lines?

[ Edited ]

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] ) )
)

 

View solution in original post


All Replies
AlB Super Contributor
Super Contributor
Posts: 1,180
Registered: ‎11-12-2018

Re: How to sum values from previous lines?

[ Edited ]

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] ) )
)

 

Highlighted
Frequent Visitor
Posts: 2
Registered: ‎01-17-2019

Re: How to sum values from previous lines?

Hi AlB,

 

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

 

thanks

Zoltán