Forum Discussion
Krishna1992
Helper I
Helper IFilter 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...
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
Krishna1992Helper I
Helper IHi 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.
az38
Community Champion
Community Championcould 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
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