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 

lets start step-by-step.

whats your data source? how it looks like? Table "Lcation-Category" is the only data source? How can we define that for India it should be only watermelon and pinapple?

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

Krishna1992's avatar
Krishna1992
Helper I
6 years ago

Hi az38 ,

I need to filter category on different location. Which means Every location may have same category or different category.

But I need to select required category for specific location. Ex. if it is India I need to select certain category, if it is US it need to select certain category.

 

Eg.

India - I need watermelon, apple

US - I need vinegar, watermelon, pinapple.

 

Likewise I need to multiple location. Only DAX is possible or can I do in query editor. Thanks for your response.