How to create a column with Accumulated Value from previous column?

[rafaelfernandes]

Hello there,

I'm trying to create a column that shows the accumulated value from the previous column (in this case in %).

Then after this I want to classify, in another column, each row that has an accumulated value <= 80% as A, 80 to 95% as B, 95% a 99% as C and 99% to 100% as D.

So the new column should have the first value as 1,47%, the second should be 1,47%+1,47%, the third should be 2,94%+1,26%, the fourth should be 4,2%+1,16% following this sequence.

Then after this column, atteribute the classification A,B,C and D as I explained above in a new column

Is this possible to compute in powerBI?

Thank you for all the possible help!

[Johanno · Accepted solution]

You could:

1. Add an index column i Power Query (1, 2, 3 etc)

2. Get the cumulative sum by: 

Cumulative = CALCULATE(SUM('Table'[Percentage]);FILTER('Table';'Table'[Index]<=EARLIER('Table'[Index])))

3. Then classification with nested ifs:

Classicifation = IF('Table'[Cumulative]<=80;"A";IF('Table'[Cumulative]<=95;"B";IF('Table'[Cumulative]<99;"C";"D")))