Forum Discussion
Increment values by row in a table
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
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!!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] ) )
2 Replies
- Jihwan_Kim
Super User
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
Community Champion
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] ) )