Forum Discussion

Analyst001's avatar
Analyst001
Frequent Visitor
5 years ago
Solved

removing items by adding a conditional line in the query

Hi There....I want to remove items from a column by adding a condition in the query....please help me how do I proceed
Need Help
  • mahoneypat's avatar
    mahoneypat
    5 years ago

    You can add a filter steps using any of your current values and then modify using the pattern below.

     

    = Table.SelectRows(#"Previous Step", each List.Contains({"CurrentItem", "FutureItem"}, [ColumnToFilter]) = false)

     

    Pat

Portrek's avatar
Portrek
Icon for Resolver III rankResolver III
5 years ago

You can just put filter in your columns e select the itens that you want or need. After the selection, load the table.

Analyst001's avatar
Analyst001
Frequent Visitor
5 years ago

I cannot use filters as one item is from the list and one is coming in the future