Forum Discussion

Jannis68's avatar
Jannis68
Frequent Visitor
8 years ago
Solved

Creating a new table in Power BI combining columns

I need to create a new table combining six columns into two columns and keep the identifiers. The exisiting table is:   question_id respondent_id Pos1 Pos2 Pos3 Neg1 Neg2 Neg3 1 1 x ...
  • v-ljerr-msft's avatar
    v-ljerr-msft
    8 years ago

    Hi Jannis68,

     

    If I understand you correctly, you should be able to use the Unpivot Columns option in Query Editor to unpivot the Pos columns and Neg columns separately to get the expected result in your scenario.

     

    For more details about how to Pivot and Unpivot with Power BI, you can refer to this article. :smileyhappy:

     

    Regards

Jannis68's avatar
Jannis68
Frequent Visitor
8 years ago

Thanks for input. Actually this is not what I was looking for.  I would like the new table to look like:

 

question_idPositiveNegative
1Pos1Neg1
1Pos2Neg2
1Pos3Neg3
2Pos1Neg1
2Pos2Neg2
2Pos3Neg3

 

 

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
8 years ago

Hi,

 

For further clarity, please take a clearer example.  Instead of xx, show some data under the Pos and negative columns and on that dataset, show your desired result.