Multiple OR

[FranckGbadamass]

Hello friends,

Can you help me with how to write below formula properly please

I was thinking about is in ["ID 1","ID 2"] as we do in SQL queries.

Thank in advance.

[FranckGbadamass]

Thank you @PhilipTreacy for your reply.

Is List.ContainsAny works with column as argument too?

Because what I really want is made the last argument of the function dynamic ie use the column of my dataset.

[FranckGbadamass]

Below what I'm trying to do:

[PhilipTreacy · Accepted solution]

Hi @FranckGbadamass 

Download example XLSX file

Yes that's correct you can use a column from another table as the list for the 2nd argument

= if List.ContainsAny({[ID]} , Table2[ID]) then true else false

Regards

Phil

[PhilipTreacy]

Hi @FranckGbadamass 

Download sample XLSX file

You can write this

= if List.ContainsAny({[ID]} , {1, 2, 3}) then true else false

regards

Phil