Power BI Newbie - Using Not In

[ejbrazell]

For give my ignorance but I am learning Power Query commands (M).  Can someone help me with the equivalent statement in Power BI for this SQL code.

SQL Statement

Select * from MyTable where Field1 not in ("AB", "AC", "FG")

Power BI Equivalent

= Table.SelectRows(MyTable, Each [Field1] ????????????

Or is there a better way.

[MarcelBeug · Accepted solution]

Probably you would have an answer much sooner if you posted your question in the "Desktop"  forum.

Anyhow, this will do the trick:

= Table.SelectRows(MyTable, each not List.Contains({"AB", "AC", "FG"}, [Field1]))

[ejbrazell]

Thanks, it works like a charm. 

As I look closer at the forum areas, I see what you mean about where I should have posted.  Looking closer at the developer area questions, I see the type of development work that is taking place there.