Hello I would like to obtain this resultI want to make a cumulative sum each in relation to my previous value, my base value is that of BindexAB11015220=15+20=35330=35+30=65440=65+40=105Result:IndexAB110152203533065440105earlier doesn't workB = IF ( test[Index] = 1, test[B] CALCULATE( SUMX( FILTER( test, test[Index] <= EARLIER(test[Index]) ), test[B] ) ))thank you for your feedback

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.

cumulative sum | Microsoft Fabric Community

Forum Discussion

Related content

cumulative sum

Cumulative SUM

Cumulative Total

Cumulative sum

Cumulative sum