Forum Discussion
Table Transformation
Hi cesarwheezer,
Thank you for reaching out to the Microsoft Fabric Forum Community, and a special thanks to the scott2718, BA_Pete and Shubham_rai955 for their prompt and helpful responses.
Could you please provide a bit more information, as suggested by BA_Pete , so we can assist you further?
Best regards,
Prasanna Kumar
Super UserHere is the simplest way to do this in Power Query.
You want:
Each Work Order ID will end up with four new columns, one for each Forecast Description.
Each column should show its matching Field Value.
Think of it like pivoting the data.
Do this:
Select the column Forecast Description.
Go to Transform, then Pivot Column.
For Values Column, choose Field Value.
For Advanced Options, choose Dont Aggregate.
Power Query will create four new columns automatically.
Each column will show the Field Value for that Forecast Description, exactly like your Excel example.