Forum Discussion
andreazambon
3 years agoHelper V
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_VermaMost 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