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

     

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