cancel
Showing results for
Did you mean:
rafaelfernandes Occasional Visitor

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

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!

1 ACCEPTED SOLUTION

Accepted Solutions
Johanno Member

## Re: How to create a column with Accumulated Value from previous column?

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")))`
Johanno Member

## Re: How to create a column with Accumulated Value from previous column?

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")))`

Announcements #### Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system. #### Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge. #### Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests! #### Power Platform Online Conference 