Running Sum Calculation

[Anonymous]

I have a column like that, i want to create new column like that.

Column1         New Column

       0                          0

       1                          4

       1                          3

       1                          2

       1                          1

       0                          0

       0                          0

       1                          2

       1                          1

       0                          0

       1                          3

       1                          2
       1                          1
       0                          0       

if the value in Column1 is 1, then the value after that will be 0. It will write the sum to the column with the first 1 value and reduce the next values ​​by 1.

Sorry for my english, it was hard to explain it 🙂

[Zubair_Muhammad · Accepted solution]

Hi @Anonymous

First add an Index Column from Query Editor

Then you can use this calculated column

New_ =
VAR FindNextZeroIndex =
    MINX (
        TOPN (
            1,
            FILTER ( Table1, [Index] > EARLIER ( [Index] ) && [Column1 ] = 0 ),
            [Index], ASC
        ),
        [Index]
    )
RETURN
    IF (
        [Column1 ] = 1,
        CALCULATE (
            SUM ( Table1[Column1 ] ),
            FILTER (
                Table1,
                Table1[Index] >= EARLIER ( Table1[Index] )
                    && Table1[Index] < FindNextZeroIndex
            )
        ),
        0
    )

[Zubair_Muhammad]

@Anonymous

See file attached as well

[Anonymous]

Thanks @Zubair_Muhammad absolutely working