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 team,
I'm looking for a help / suggestion to transform rows to columns.
Attached is the sample data set for reference purposes.
Input Source table:
Model No. | Type | Project | Category | Count | List | Units |
Dynamic | Type1 | PRJ1 | Category1 | 25 | 2500 | 4.15 |
Dynamic | Type1 | PRJ1 | Category1 | 50 | 20 | 3.38 |
Dynamic | Type1 | PRJ1 | Category1 | 100 | 25 | 3.17 |
Dynamic | Type1 | PRJ1 | Category1 | 150 | 30 | 3.17 |
Dynamic | Type1 | PRJ1 | Category1 | 35 | 3.17 | |
Dynamic | Type1 | PRJ1 | Category1 | 200 | 45 | 8.19 |
Dynamic | Type1 | PRJ1 | Category1 | 250 | 50 | 9.23 |
Output source:
Model No. | Type | Project | Category | Count1 | List1 | Units1 | Count2 | List2 | Units2 | Count1 | List2 | Units2 | Count3 | List3 | Units3 | Count4 | List4 | Units4 | Count5 | List5 | Units5 | Count6 | List6 | Units6 |
Dynamic | Type1 | PRJ1 | Category1 | 25 | 2500 | 4.15 | 50 | 20 | 3.38 | 100 | 25 | 3.17 | 150 | 30 | 3.17 | 35 | 3.17 | 200 | 45 | 8.19 | 250 | 50 | 9.23 |
Thanks in advance.
Kind regards,
Anand
https://1drv.ms/f/s!Aj7kf6Fnqc5SwmD-8Jv-HKxKd9N8
Solved! Go to Solution.
Hi all,
I have found the solution for the question that I posted for help last evening. Hope this helps, how I achieved the desired results.
Regards,
A!
Hi all,
I have found the solution for the question that I posted for help last evening. Hope this helps, how I achieved the desired results.
Regards,
A!
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 |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |