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.
I am building a report of rating data. My main table has columns with different metrics and rows with Excellent, Good, Fair or Poor. I want to count the total of each rating type for each metric in a separate table.
Column 1 Column 2 Column 3
Excellent Good Fair
Excellent Excellent Poor
Fair Good Excellent
Poor Fair Fair
Excellent Good Good
Good Poor Good
New table:
All Columns Excellent Count Good Count
Column 1 3 1
Column 2 1 3
Column 3 1 2
I believe I'll need to add a Custom Column in the power query editor, but I am unsure what the DAX should be. Also, I am not sure how to join this new table to the main Fact table.
Solved! Go to Solution.
Hi, @Anonymous
It's difficult to create a relationship between new table and fact table based on current fields.
Please try following step to transform data in PowerQuery.
1.unpivot these columns
2.Group table by New column 'Attribute' and 'Value'
3. pivot column like below:
Result:
Best Regards,
Community Support Team _ Eason
Hi, @Anonymous
It's difficult to create a relationship between new table and fact table based on current fields.
Please try following step to transform data in PowerQuery.
1.unpivot these columns
2.Group table by New column 'Attribute' and 'Value'
3. pivot column like below:
Result:
Best Regards,
Community Support Team _ Eason
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
88 | |
63 |