Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

cumulative sum

Hello I would like to obtain this result I want to make a cumulative sum each in relation to my previous value, my base value is that of B index A B 1 10 15 2 20 =15+20=35 3 30...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi Anonymous ,


    powerbidev123's reply could return the result you want. However if A1 is not 10, it will not work. I don't suggest you to use EARLIER() function, it may cause bad performance if you have large size of data.

    You can also try my code to create a calculated column.

    B =
VAR _B1 = 15
VAR _CurrentIndex = 'Table'[index]
RETURN
    IF (
        'Table'[index] = 1,
        _B1,
        _B1
            + CALCULATE (
                SUM ( 'Table'[A] ),
                FILTER ( 'Table', 'Table'[index] > 1 && 'Table'[index] <= _CurrentIndex )
            )
    )

    Result is as below.

     

    Best Regards,
    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

powerbidev123's avatar
powerbidev123
Solution Sage
1 year ago

Hi Anonymous , Let me know if this helps

B =
5 + SUMX(
    FILTER(
        'Table (3)',
        'Table (3)'[Index] <= EARLIER('Table (3)'[Index])
    ),
    'Table (3)'[A]
)