Hi, I have created several new columns which I then want to rotate. The problem is that these new columns don't appear in Power Query. So I think that to rotate these columns I have to create a formula to build the pivot table. Is it true? And what formula to do that?

Jeremy19 1. What do you mean by "rotate" the columns?2. What are you doing exactly? Reading from a data source with Power query and adding columns in thta data source?

1) I would like to rotate the columns to have for exemple : Player ColA ColB A 10 20 B 13 23 -> Player Col Value A ColA 10 A ColB 20 B ColA 13 B ColB 23 2) I need to create this column A and B as in the example but they don't appear in Power Query after creating them

You can use unpivot to "rotate" them - https://support.office.com/en-us/article/unpivot-columns-power-query-0f7bad4b-9ea1-49c1-9d95-f588221c7098 Where are you creating the new columns? if its in the underlying datasource you may need to modify your query to pick them up

I create the new columns in Power Bi Desktop not in Power Query. So I have to enter a formula to create the pivoted table so I can't use unpivot. But there may be something I misunderstood in Power Bi...

is there a reason you create them in the model rather than during the load?

Pivot with new columns | Microsoft Fabric Community

11 Replies

AlB
Community Champion
7 years ago
Jeremy19

1. What do you mean by "rotate" the columns?
2. What are you doing exactly? Reading from a data source with Power query and adding columns in thta data source?
- Jeremy19
  Helper III
  7 years ago
  1) I would like to rotate the columns to have for exemple :
  
  Player ColA    ColB
  A 10    20
  
  B 13    23
  
  ->
  
  Player Col    Value
  A    ColA    10
  A    ColB 20
  B    ColA    13
  B    ColB 23
  
  2) I need to create this column A and B as in the example but they don't appear in Power Query after creating them
  - itchyeyeballs
    Impactful Individual
    7 years ago
    You can use unpivot to "rotate" them - https://support.office.com/en-us/article/unpivot-columns-power-query-0f7bad4b-9ea1-49c1-9d95-f588221c7098
    
    Where are you creating the new columns? if its in the underlying datasource you may need to modify your query to pick them up

Forum Discussion

Pivot with new columns

11 Replies

Related content

Power BI Pivot Columns ?

Pivot issue

Pivot / Unpivot?

Power Query Pivoting columns issue

How to pivot Multiple Columns