cancel
Showing results for
Did you mean:
Highlighted
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 #### Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future. Learn the answers to some of the questions asked during the Amanda Triple A event. #### October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.  Top Kudoed Authors
Users Online
Currently online: 402 members 3,588 guests
Recent signins:
• besthyde • water_hydration • qwertzuiop • jijoyav • kabra_ashish • hverburg • josemanuelcayon • ClairesAntRea • Bartnick • bball • nisalm_bi • marina21 • danielkinch • ZzzzNian 