Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to Solution.
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
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.
User | Count |
---|---|
98 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
59 |