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 wa...
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

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

    • cwstad's avatar
      cwstad
      Frequent Visitor
      8 years ago

      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