Forum Discussion

ZoltanFut's avatar
ZoltanFut
New Member
7 years ago
Solved

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

Need Help
  • AlB's avatar
    AlB
    7 years ago

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

     

2 Replies

  • AlB's avatar
    AlB
    Community Champion
    7 years ago

    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's avatar
      ZoltanFut
      New Member
      7 years ago

      Hi AlB,

       

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

       

      thanks

      Zoltán