I have a table with sales = "avocado", in the column= "Region" I have cities but also states. I want to drop all sales with a state in column."region". I did it on Excel but I want to learn the process in powerBI desktop.
My idea was the following:
I have a table with state names (they are well written in both tables).
So i would add a column on avocado.table making a vlookup on states.table invoking the 2nd column with value "1".
With this new column with a 1 for each state sale. I would just filter that column unchecking the "1" and all remaining rows would be citie's sales.