Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!!