Forum Discussion
dkay84_PowerBI
Microsoft Employee
Microsoft EmployeePower Query Challenge for you M Ninjas
I would like a query or function that will append every column in a table into a single list with dups removed. The names and number of columns is random so the solution needs to be dynamic.
How about:
List.Distinct(List.Union(Table.ToColumns(Tabel1)))
(This is the entire query code)
MarcelBeug
Community Champion
Community ChampionHow about:
List.Distinct(List.Union(Table.ToColumns(Tabel1)))
(This is the entire query code)
This is pretty awesome. Is it possible to transpose the list so that column headers remain and we still get distinct values for each column? Kind of like a transposed version of: List.Distinct(Table.ToColumns(Tabel1)) except only unique values.
Thank you sir,
Alec