Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Split the unique row into multiple rows in a new table based on the the Y/N columns

Hi All,

 

I am looking to split the unique row into multiple rows in a new table based on the Y/N columns to the unique data. For examaple I would like to have two rows the Incident ID "3256031" with a column veh Type with Car and Good vehicle in it.

Current data

 

 

Required Output:

 

 

Thanks for your help in  advance.

 

Thanks and regards

Gautam

 

Need Help
  • Pragati11's avatar
    Pragati11
    6 years ago

    Hi Anonymous ,

     

    You can try doing thiss in Query Editor in Power BI.

     

    Consider following smaple data:

    Then selected the Car and Goods Vehicle columns and Unpivot them:

     

    You end up following:

     You can rename the resulting columns as per your requirement.

     

    Thanks,

    Pragati

     

1 Reply

  • Pragati11's avatar
    Pragati11
    Icon for Super User rankSuper User
    6 years ago

    Hi Anonymous ,

     

    You can try doing thiss in Query Editor in Power BI.

     

    Consider following smaple data:

    Then selected the Car and Goods Vehicle columns and Unpivot them:

     

    You end up following:

     You can rename the resulting columns as per your requirement.

     

    Thanks,

    Pragati