Forum Discussion
Filter based on criteria
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
how can we understand that for India doesn't need vinegar, for USA - apple? is there a rule or it should be selected by user?
do not hesitate to give a kudo to useful posts and mark solutions as solution
Hi az38 ,
I was not a rule or selected by user, it was my requirement to select only required category. User only requires specific category from each category.
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
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