Filtering rows with multiple conditions

Question

Hello,&nbsp;I have a problem with filtering certain rows.&nbsp;I would like to filter out from all of my data rows, which firstly in column "Category" are "Candies" and column "Accounts" are anything else but "123" and "345". So I would like to exclude from my data all the other&nbsp;Candies accounts beside "123" and 345". This&nbsp;Candies filtering is important as I have like hundred other category as well.&nbsp;&nbsp;Best regards,Kelly&nbsp;&nbsp;

mfelix · Answer

Hi&nbsp;KellyLen,&nbsp;In the power query add this column to your data:&nbsp;if [Category] &lt;&gt; "Candies"

then "keep"

else 
        if  ([Category] = "Candies" and [Accounts] = 123 ) 
        or  ([Category] = "Candies" and [Accounts] = 658 )   
       then "keep" 
else ""&nbsp;Then just do a filter on keep and delete the column you just created:&nbsp;&nbsp;Regards,MFelix

ashish_mathur · Answer

Hi,&nbsp;Have you tried applying these conditions in the Query Editor?&nbsp; If yes, then what problem do you face?

kellylen · Answer

Hi!&nbsp;&nbsp;Yes, I tried to filter it in query editor, but then it filtered all the "Candies" out and did not left any candies to the data. And advcanced filtering does not allow me to create a condition "anything else but "123""?&nbsp;

ashish_mathur · Answer

Hi,&nbsp;Share some data to work with and also show your expected result.

kellylen · Answer

I created an example to excel:And result should be like this:All the other candies with accounts, which are not 123 and 345, are gone.&nbsp;&nbsp;Does this help?&nbsp;

Forum Discussion

Filtering rows with multiple conditions

9 Replies

Related content

Multiple conditions Index

Multiple Donut charts with conditions

Conditional Column with Multiple Conditions

Advanced filtering in power query - multiple conditions

Filtering a table with multiple conditions from multiple switches pulled from another table