Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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...
Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    5 years ago

    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's avatar
    themistoklis
    5 years ago

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

     

     

     

     

     

themistoklis's avatar
themistoklis
Community Champion
5 years ago

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