Using List.Contains to simplify table filter

[serky]

Hello
I am very new to Power Query so please bear with me. Can someone help with a basic question?


I have used the Power Query editor to filter a column. It shows:
#"Filter CLASS"= Table.SelectRows(#"Uppercase CLASS", each ([#"CLASS"] = "Chemistry" or [#"CLASS"] = "Physics")

I would like to simplify this code as the actual filter expression will have many identifiers. I have tried the following (plus many variations) but they have not worked:

#"Filter CLASS"= Table.SelectRows(#"Uppercase CLASS", each List.Contains({"Chemistry","Physics"},[#"CLASS"]))

What is the correct syntax?

Thanks

 

[citizenbh]

Put it in big brackets field [#"CLASS"]:
#"Filter CLASS"= Table.SelectRows(#"Uppercase CLASS", each List.Contains({"Chemistry","Physics"},{[#"CLASS"]}))

 

[citizenbh]

Or before, change field name [#"CLASS"] in [CLASS]

#"Filter CLASS"= Table.SelectRows(#"Uppercase CLASS", each List.Contains({"Chemistry","Physics"},[CLASS]))

 

[serky]

This worked perfectly. Thanks for your help.

Will now be researching more about M syntax!