Forum Discussion

cwstad's avatar
cwstad
Frequent Visitor
8 years ago
Solved

Query to exclude multiple items.

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

 

Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    8 years ago

    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

4 Replies

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee
    8 years ago

    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's avatar
      cwstad
      Frequent Visitor
      8 years ago

      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's avatar
        v-yulgu-msft
        Microsoft Employee
        8 years ago

        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