Forum Discussion
Filter out row using Table.SelectRows and conditional if/and
Hi all, I need to drop a row from my table in power query (Excel). I presume I need to filter that row out. The trouble is that other rows also have than same value and I dont want to filter out th...
Hi Anonymous
You can filter to Bob and 26 and add not like below.
= Table.SelectRows(#"Changed Type", each not ([Indicator] = "bob" and [Total] = 26))
Best Regards,
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.
Hi Anonymous
You can try the below.
= Table.SelectRows(#"Changed Type", each not ( ( [Indicator] = "bob" and [Total] = 26 ) or ( [Indicator] = "jane" and [Total] = 21 ) or ( [Indicator] = "jon" and [Total] = 15 ) ) )Best Regards,
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.
How can i select reow different from list, i try this but it doesn't wor?
= Table.SelectRows(#"Colonne conditionnelle ajoutée2", each [Date de base] <> #"date du jour -30"=true)
thnks