Filter and add a conditional column based on a list in Power Query
Use M code to remove unwanted values in a column and see how to add a conditional column based on a list in Power Query
Use Table.SelectRows(), List.Contains() in M code
-- Subscribe for more !!