Forum Discussion
Solved
Data Import and unPivot
Hi There I am new to PowerBI. My source data is sample sales breakdown of various categories. I would like to unpivot and organize information vertically. Given few tries but didn't...
NewStep=#table({"ID","Category","Quantity"},List.TransformMany(Table.ToRows(PreviousStep),each List.Split(List.Skip(_),2),(x,y)=>{x{0}}&y))
Hi msc7808
Daniel has provided a perfect solution. You can copy his code into Advanced Editor to add a new step and replace "PreviousStep" with the last step name in your APPLIED STEPS pane like #"Changed Type".
How to add a step or steps to an existing power query - YouTube
Best Regards,
Community Support Team _ Jing