Forum Discussion
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 t...
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
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