Keeping Rows Based on Another Column

[Anonymous]

I have a table that has Employee names and their work area.

I would like to only keep the rows with the employees in certain work areas.

I know I can filter but I will be updating the data frequently and their may be times when no one is a work area that prevousily had people in it or people are now in a work area that prevousily had no one in it. Due to this I don't think just filtering the rows from the drop down is a good option.

How can I write this into my power query?

[mahoneypat · Accepted solution]

You can hard code in all the areas with this approach.  Add a custom column with a formula like this

= if List.Contains({"Area1", "Area2", "Area3"}, [AreaColumnName]) then "Y" else "N"

and then just filter out the "N" rows on that new column.  You can then modify the list of areas over time if changes occur.

Pat