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.
Dear community,
I am trying to use the PowerBI Power Query Editor and try to transform/combine the following data:
context | time | value | uom |
10 | 12:00 | 123 | cycle |
10 | 12:00 | 50 | mm |
11 | 12:50 | 124 | cycle |
11 | 12:50 | 52 | mm |
to
context | cycle | mm | time |
10 | 123 | 50 | 12:00 |
11 | 124 | 52 | 12:50 |
Is this possible with the functions in the Power Query Editor ribbon? (if so, at which functions should I look into)
Solved! Go to Solution.
You can use Pivot Column under transform tab.
Select uom column, Pivot, values column: value, advanced options: Don't aggregate.
You can use Pivot Column under transform tab.
Select uom column, Pivot, values column: value, advanced options: Don't aggregate.