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))
NewStep=#table({"ID","Category","Quantity"},List.TransformMany(Table.ToRows(PreviousStep),each List.Split(List.Skip(_),2),(x,y)=>{x{0}}&y))