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.
Is it possible to transpose the table in this way?
I have tried with Transpose and undo dynamization of powerbi columns but I have not been able to do it.
the result should look like this
columna1 | ph | grado | temperatura |
1 | 10 | 5 | |
2 | 10 | 8 | |
3 | 10 | 41 | 23 |
here is the pbix
https://www.dropbox.com/s/mzqzwokd0mvxiuw/transpose.pbix?dl=0
thank you in advance for your help
Solved! Go to Solution.
You can Pivot (from the Transform menu in Power Query) Column2 using Column3 in Values.
With the data provided - 'Don't Aggregate' should work (from the Advanced options)
You can Pivot (from the Transform menu in Power Query) Column2 using Column3 in Values.
With the data provided - 'Don't Aggregate' should work (from the Advanced options)
¡¡thank you very much HotChilli!!
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 |
---|---|
97 | |
97 | |
82 | |
74 | |
66 |
User | Count |
---|---|
121 | |
105 | |
102 | |
82 | |
72 |