Query to exclude multiple items.

[cwstad]

Hi all, im looking to exclude a large number of text from a report (~500), some examples below. I've exceeded the amount on the basic filtering, so was looking for a query to assist or a different way. 

Thanks in advance.

system-replmon
Spam Report
orion
mcafee.alerts
wsusadmin

[v-yulgu-msft]

Hi @cwstad,

Please refer to this M code:

= Table.SelectRows(#"PreviousStep", each not List.Contains({"system-replmon","Spam Report","orion","mcafee.alerts","wsusadmin"},[Column1]))

Best regards,

Yuliana Gu

[cwstad]

Morning i have tried to run the code but i get the following error. I have also tried to change previousstep to first_name 

. 

Data im trying to filter

[v-yulgu-msft · Accepted solution]

Hi @cwstad,

From my original post, you should replace the "#PreviousStep" with the actual step name, not the first_name.

Take below image as an example, the underlined part is the previous step.

Best regards,

Yuliana Gu

[cwstad]

Hello i'm still not getting any joy with this. 

Im opening the query editor pasting

= Table.SelectRows(#"PreviousStep", each not List.Contains({"system-replmon","Spam Report","orion","mcafee.alerts","wsusadmin"},[Column1]))

Changing the #perviousstep" to the step named vavigation in the applied steps window.

However i get the error 

What am i getting wrong.

Thanks