Forum Discussion
cesarwheezer
8 months agoNew Member
Table Transformation
Hello everyone, I am attempting to add four new column headers under the "Forecast Description" section and populate them with the corresponding field values. I have created an Excel table to ill...
- Anonymous8 months ago
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
cesarwheezer
8 months agoNew Member
Hello team,
I was able to use the existing dataset transformation to create my visuals. Appreicate all your help!
- scott27188 months agoAdvocate I
Did you end up adding in an additional identifier to ensure you had the 4 pivoted fields correctly grouped? I don't think your solution was feasible without doing that, unless you aggregated somehow to reduce the dataset to only unique forecasted description category and work order ID combinations