Forum Discussion
Power query : Need help on math column/Header value
Hello, I need your help on power query to retrieve data from a second table according to the header column and the value of the first column. I have a table with country, city and population. A se...
Regarde du coté des options avancées du pivot pour choisir "Nombre".
Table.Pivot(Source, List.Distinct(Source[Country]), "Country", "Nb", List.Count)
Comme ça on obtient des 1 si la valeur existe et des 0 sinon.
Stéphane