Forum Discussion
Solved
Filterering Columns with Dynamic Names
Hello all, I have table with product and store information. I transform this table to another table, first grouped based on Product Type, then pivoted it. Then I filtered Product Type Z1 where o...
let
Source = YourSource,
Group = Table.Group(Source, {"Product"},
{{"Product Type List", each List.Distinct([Product Type])},
{"Store", each Text.Combine([Store], "-")}}),
Filter = Table.SelectRows(Group, each [Product Type List]={"Z1"})
in
Filter
Stéphane
