Forum Discussion
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...
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 ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous , Try using
Cumulative B =
CALCULATE(
SUM(test[A]),
FILTER(
ALL(test),
test[Index] <= MAX(test[Index])
)
) + MIN(test[B])
Anonymous , Try using
B =
IF (
test[Index] = 1,
test[B],
test[A] +
CALCULATE(
MAX(test[B]),
FILTER(
test,
test[Index] = EARLIER(test[Index]) - 1
)
)
)