Forum Discussion

andreazambon's avatar
andreazambon
Helper V
3 years ago
Solved

function that works as list

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.

 

  • 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

1 Reply

  • Vijay_A_Verma's avatar
    Vijay_A_Verma
    Most Valuable Professional

    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