Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
97 | |
80 | |
67 | |
63 |
User | Count |
---|---|
145 | |
111 | |
104 | |
84 | |
64 |