Forum Discussion
Combine Values into groups
Hello, We have a table containing "Job ID", "Job Type" and "Revenue" (and a lot more - not important). The problem is we have 30+ job types, and we would like to put them into 4 groups. The ...
Right,
Creating a group following the link i posted before should work fine
Use grouping and binning in Power BI Desktop
In short, right click on the column -> New group, in group type choose list and than group them in any way you like
Thanks Anonymous for sample data.
Is NEW column is your expected output ? or that is what need to considered for JobType to calculate Revenue - Please confirm.
Anonymous Hope this is what you are after..
Create a New Table as below
Test310Out = SUMMARIZE(Test310Groups,Test310Groups[JobType],"Revenue",SUM(Test310Groups[Revenue]))
Then, add Rank field to the above table as below
Rank = RANKX(Test310Out,Test310Out[Revenue],,DESC,Dense)
Finally, add a Grouping field based on the Revenue (which we have assigned Rank in above step)
Group = IF(Test310Out[Rank]<=5,"Type A",IF(Test310Out[Rank]<=10,"Type B","Other"))