Forum Discussion

dkay84_PowerBI's avatar
dkay84_PowerBI
Microsoft Employee
9 years ago
Solved

Power 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.
Need Help
Tutorial Requests
  • MarcelBeug's avatar
    MarcelBeug
    9 years ago

    How about:

    List.Distinct(List.Union(Table.ToColumns(Tabel1)))

    (This is the entire query code) 

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Will a single-column table result do? - e.g.:

let
    Source = Table1,
    #"Added Index" = Table.AddIndexColumn(Source, "Index", 1, 1),
    #"Unpivoted Other Columns" = Table.UnpivotOtherColumns(#"Added Index", {"Index"}, "Attribute", "Value"),
    #"Removed Other Columns" = Table.SelectColumns(#"Unpivoted Other Columns",{"Value"}),
    #"Removed Duplicates" = Table.Distinct(#"Removed Other Columns")
in
    #"Removed Duplicates"