Forum Discussion
Creating a cumulative column breaking on another column - help !
Hi,
I am new to Power BI and I am looking for a very simple way to bring back the 'Cume' column (shown in the example below) into my dataset so I can filter on the Cume = '1' to get a unique value. I know that I will have to sort the data on 'Colour' in order to get the column in the right order first but after that I am at a loss. I don't want to group the data or anything else - just simply create the cumulative value based on the count breaking on the Colour Column.
| Colour | Count | Cume |
| Red | 1 | 1 |
| Red | 1 | 2 |
| Red | 1 | 3 |
| Blue | 1 | 1 |
| Green | 1 | 1 |
| Yellow | 1 | 1 |
| Yellow | 1 | 2 |
| Yellow | 1 | 3 |
| Orange | 1 | 1 |
I am sure there is a very simple way to do this for a beginner but I have not been able to figure it out yet - any help would be greatly appreciated. Many thanks.
Hi, a way to solve this:
in Edit Query:
Add a Index Column --Close & Apply
After this:
Create a new column
Cume=RANKX(FILTER(Table1,Table1[Colour]=EARLIER(Table1[Colour])),Table1[Index],,ASC)
Regards
Victor
Lima - Peru
2 Replies
Hi, a way to solve this:
in Edit Query:
Add a Index Column --Close & Apply
After this:
Create a new column
Cume=RANKX(FILTER(Table1,Table1[Colour]=EARLIER(Table1[Colour])),Table1[Index],,ASC)
Regards
Victor
Lima - Peru
That is great Victor - a simple and elegant solution. Thank you very much for your help on this.
Chris.
