The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
Solved! Go to Solution.
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:
Table.SelectRows(#"name Of Previous Step", each Text.Lower(Text.Trim([column2])) <> "buy")
The easiest way to do this, is:
Table.SelectRows(#"name Of Previous Step", each Text.Lower(Text.Trim([column2])) <> "buy")
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!
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.
User | Count |
---|---|
5 | |
4 | |
3 | |
2 | |
1 |
User | Count |
---|---|
16 | |
15 | |
11 | |
6 | |
6 |