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" wi...
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

     

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