Forum Discussion

msc7808's avatar
msc7808
Regular Visitor
4 years ago
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 have success so far.

 

 

Can someone please share their insight into this?

 

Thanks


Manny

 

Need Help
  • wdx223_Daniel's avatar
    wdx223_Daniel
    4 years ago

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

2 Replies

  • wdx223_Daniel's avatar
    wdx223_Daniel
    Community Champion
    4 years ago

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