The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
I have the following in a single table:
Key TotalPoints TotalPointsA TotalPointsB TotalPointsC TotalPointsD
1 2 2 null null null
1 5 null null 5 null
1 8 null 8 null null
What I want is the final table to look like:
Key TotalPointsA TotalPointsB TotalPointsC TotalPointsD
1 2 8 5 null
Solved! Go to Solution.
I was able to do this by using the Pivot feature.
For those that need to do something similiar, here is the video I found: Power Query: How to collapse Multiple Rows to a Single Row (youtube.com)
I was able to do this by using the Pivot feature.
For those that need to do something similiar, here is the video I found: Power Query: How to collapse Multiple Rows to a Single Row (youtube.com)
Hi
you can sum thte totalpoints columns except the key column as below
I want to do it in PowerQuery as part of the transform, as I am using the data in a stacked bar chart.
User | Count |
---|---|
71 | |
64 | |
62 | |
50 | |
28 |
User | Count |
---|---|
117 | |
75 | |
62 | |
54 | |
43 |