Forum Discussion

mondegren's avatar
mondegren
New Member
9 years ago
Solved

Importing irregular group data?

I'm new Power BI and am trying to import data that is irregular.  Specifically: Date | Order# | Attribute group where there are 3 attributes that can repeat 0 to many times (e.g. Color, Size, Quanti...
  • Vvelarde's avatar
    Vvelarde
    9 years ago

    mondegren

     

    Hi, please follow the steps in the image below

     

     

    Regards

     

    Victor

    Lima - Peru

Vvelarde's avatar
Vvelarde
Community Champion
9 years ago

mondegren

 

Hi, please follow the steps in the image below

 

 

Regards

 

Victor

Lima - Peru

  • mondegren's avatar
    mondegren
    New Member
    9 years ago

    Thanks Vvelarde!! This works great!

     

    I had been splitting the grouped data first and then trying to un-pivot.  The trick is to unpivot the GROUPED data, and THEN split the grouped data into the regular columns.

     

    Thanks again!

    Mondegren