Forum Discussion

Krishna1992's avatar
Krishna1992
Helper I
6 years ago
Solved

Filter based on criteria

Hello everyone,   I have 2 columns in my table, one is category and other is product.   I need to select/filter only required category based on product.   Something like below table, Produc...
Need Help
  • az38's avatar
    az38
    6 years ago

    Krishna1992 

    could you do it manually?

    go to the Power Query Editor pick your table, add Custom column like

    = Text.Combine({[Location], "-", [Category]})

    then filter out all you don't need like in Excel

    do not hesitate to give a kudo to useful posts and mark solutions as solution

az38's avatar
az38
Community Champion
6 years ago

Krishna1992 

could you do it manually?

go to the Power Query Editor pick your table, add Custom column like

= Text.Combine({[Location], "-", [Category]})

then filter out all you don't need like in Excel

do not hesitate to give a kudo to useful posts and mark solutions as solution

az38's avatar
az38
Community Champion
6 years ago

or create a DAX calculated column

=CONCATENATE([Location];[Category])

and filter out in the visual

do not hesitate to give a kudo to useful posts and mark solutions as solution