Solved: Pivot with multiples columns

Anonymous · ‎02-10-2023

Hello, close this question, but not exactly ...

https://community.powerbi.com/t5/Desktop/Dynamic-quot-Pivot-quot-Table/m-p/3054134#M1038032

I would like to pivot a table using two columns, could you help me ?

Thank you

Pierre

Anonymous · ‎02-10-2023

Thank you ti a French forum : here is the solution :

let
Source = Excel.CurrentWorkbook(){[Name="Tableau5"]}[Content],
#"Colonne dynamique" = Table.Pivot(Source, List.Distinct(Source[Country]), "Country", "Choice")
in
#"Colonne dynamique"

Pierre

View solution in original post

Anonymous · ‎02-10-2023

Thank you ti a French forum : here is the solution :

let
Source = Excel.CurrentWorkbook(){[Name="Tableau5"]}[Content],
#"Colonne dynamique" = Table.Pivot(Source, List.Distinct(Source[Country]), "Country", "Choice")
in
#"Colonne dynamique"

Pierre