Increment values by row in a table

[Anonymous]

Hello, 

I need your help if someone knows how to do this please, I have a table with values and I want to increment values by row.

The result I'm looking for is 

do you have an idea if that is doable ? 

Thank you so much for the support 

[Jihwan_Kim · Accepted solution]

Hi, @Anonymous 

please try the below.

By the way, the table name that I assigned is Data.

Cumulate Total =

CALCULATE( SUM(Data[Value]), FILTER( ALLSELECTED( Data[Index]), Data[Index] <= MAX(Data[Index])))

Did I answer your question? Mark my post as a solution!

Appreciate your Kudos!!

[themistoklis · Accepted solution]

@Anonymous 

Try any of the following 2:

Running Total Measure = 
CALCULATE (
    SUM ( Table[Value] ),
    FILTER( ALL (Table ),
    Table[Index] <= MAX( Table[Index] ))
)

Running Total COLUMN =
CALCULATE (
    SUM ( 'Table'[Values] ),
    ALL ( 'Table' ),
    'Table'[Index] <= EARLIER ( 'Table'[Index] )
)

[Jihwan_Kim · Accepted solution]

Hi, @Anonymous 

please try the below.

By the way, the table name that I assigned is Data.

Cumulate Total =

CALCULATE( SUM(Data[Value]), FILTER( ALLSELECTED( Data[Index]), Data[Index] <= MAX(Data[Index])))

Did I answer your question? Mark my post as a solution!

Appreciate your Kudos!!