dataflow gen2 filter

Hi arkiboys2 ,

Thanks for the reply from frithjof_v . The syntax he provided is basically correct, with a small modification on my part.

You mean you want to filter out the data in Column2 with value 'Buy' or 'buy' right, am I understanding it correctly?

This is the data I created to use for testing:

ID            Column2

1             buy

2             sales

3             Twins

4             Buy

5             Boy

6             Girl

7             girl

8             Buy

9             buy

10           buy

Modify the code as follows:

Table.SelectRows(#“Changed column type”, each Text.Lower(Text.Trim([Column2])) <> “buy”)

The final display is as follows:

If you have any other questions please feel free to contact me.

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

The easiest way to do this, is:

1. In the user interface, make a random filter selection. In Column2 filter dropdown, choose some random value. It doesn't matter which value you choose.
2. The previous step will automatically generate some M code, where the Table.SelectRows function is used.
3. Then, manually replace the contents of the Table.SelectRows function with the actual code:

Table.SelectRows(#"name Of Previous Step", each Text.Lower(Text.Trim([column2])) <> "buy")