Forum Discussion
Filter based on a value in another column
Hello, I have a table with different values and a column in which the same values are per group. If now the target which has an x is completed, all others of the same group including the complet...
AlienSx
Super User
Super Userhello, -ThomasHermann filter your table (Col_J = "x" and Col_O = "completed"), extract those IDs and filter your original table once again by Col_P. Smth like this
completed = List.Buffer(
List.Distinct(
Table.SelectRows(
your_table,
each [Col_J] = "x" and [Col_O] = "completed"
)[Col_P]
)
),
filter = Table.SelectRows(
your_table,
each List.Contains(completed, [Col_P])
)