Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
arkiboys2
Helper IV
Helper IV

dataflow gen2 filter

in dataflow gen2 filter how to have this applied?

column2 not equal to lower(trim('buy'))

 

so if the value is 'Buy' or 'buy' then I want to make sure the column2 is not equal to either one of these.

 

thank you

2 ACCEPTED SOLUTIONS
Anonymous
Not applicable

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:

vhuijieymsft_0-1731034817722.png

 

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!

View solution in original post

frithjof_v
Super User
Super User

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")

View solution in original post

3 REPLIES 3
frithjof_v
Super User
Super User

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")

Anonymous
Not applicable

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:

vhuijieymsft_0-1731034817722.png

 

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!

frithjof_v
Super User
Super User

This is what ChatGPT gave me:

 

= Table.SelectRows(#"yourTableName", each Text.Lower(Text.Trim([column2])) <> "buy")

 

 

Does it work for your case?

 

* the yourTableName shall be replaced by the name of the preceding step in your M query.

Helpful resources

Announcements
Fabric July 2025 Monthly Update Carousel

Fabric Monthly Update - July 2025

Check out the July 2025 Fabric update to learn about new features.

July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.