function that works as list

[andreazambon]

Hi there, 

I need to filter some rows in my table. 

I need something like this code:

if event_id is in {10010, 10011, 10013} then 1 else 0

in order to mark with 1 the rows which have the event_id in the list that I write between braces. I can write another event_id if I need. Which function of PowerQuery is useful to reach this? Thanks.

[Vijay_A_Verma · Accepted solution]

Use following-if event_id is not a column, remove [ ] from [event_id]

if List.Contains({10010, 10011, 10013}, [event_id]) then 1 else 0