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 everyone,
I am trying to group several columns (which represent subcategories) to main categories. My data looks like this:
Commitment | Responsiveness | Appearrance | Pragmatism | Customization | Proactivity | Innovation |
2 | 5 | 2 | 3 | 5 | 2 | 1 |
3 | 3 | 4 | 3 | 5 | 1 | 3 |
Now I would like to group the first three columns into the category "Personality" and the last four to "Customer focus", in able to create numeric KPIs based on the main category (e.g. the average for Personality as a KPI visual).
Any help is appreciated! 🙂
Solved! Go to Solution.
@radu92,
You would need to add new column to calculate average of mulitiple columns.
Regards,
Lydia Zhang
Could you please post your expected result in table? How do you want to calculate these values of different columns when you group them into categories?
Regards,
Lydia Zhang
I would like to have the average of the subcategories as the main category. I solved it now by just adding a new column that calculates the AVG(column1, column2, etc.), but I was wondering if this could be done without an extra column.
@radu92,
You would need to add new column to calculate average of mulitiple columns.
Regards,
Lydia Zhang
Thanks! That's what I did 🙂
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 |
---|---|
107 | |
99 | |
76 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |