Forum Discussion
satishorre20
Helper II
1 year ago"IN" operator missing in Power Query filters
Good afternoon, I am trying to find the option to see "in" clause filter in Power query. As per the documentation, I see "in" operator is available to use multi-value parameters ( please refer "...
- Anonymous1 year ago
Hi satishorre20 ,
I understand that it might be a bit unclear, so let me provide more details.
When you're applying a filter in Power Query and the "In" filter option isn't visible in the main filter menu, here's what we can do:
- If the "In" filter isn't visible in Power Query. Apply any filter to the column (e.g., Text or Number filter).
- In the Query Settings pane, click the gear icon next to the filter step.
- In the filter dialog, select "In" from the dropdown and enter your values.
- If In operator is not visible,try using below:
create a custom column with List.Contains({"Value1", "Value2"}, [ColumnName]) and filter based on that column.
I hope this helps you.if so consider accepting it as solution.
Thank you for your cooperation.Have a great day!
Regards,
Pallavi.
Chewdata
Responsive Resident
1 year agoHey!
I think that for filtering List.Contains(list, [column]) and List.Contains(list, [column]) = False are the way to go as options for in and not in