Forum Discussion
andreazambon
Helper V
3 years agofunction 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...
- 3 years ago
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
Vijay_A_Verma
Most Valuable Professional
3 years agoUse following-if event_id is not a column, remove [ ] from [event_id]
if List.Contains({10010, 10011, 10013}, [event_id]) then 1 else 0