Forum Discussion

jamuka's avatar
jamuka
Helper IV
1 year ago
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...
Need Help
  • slorin's avatar
    slorin
    1 year ago

    jamuka 

    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 

slorin's avatar
slorin
Super User
1 year ago

Hi jamuka 

 

let
Source = YourSource
Group = Table.Group(Source, {"Product"}, {{"Product Type List", each [Product Type]}, {"Data", each _}}),
Filter = Table.SelectRows(Group, each [Product Type List]={"Z1"}),
Combine = Table.Combine(Filter[Data])
in
Combine 

Stéphane