Filter in Power Query

[AllanBerces]

Hi good day,

Can anyone help me on filtering the Power Query, from my table i have a Rank column and Daily Progress. What I required is 

- If the Rank is equal to 1 and the Daily Progress is equal to negative then hide it from the table.

Thank you

[Akash_Varuna · Accepted solution]

Hi @AllanBerces  , Try These please

Open Power Query, select your table, and go to the Filter Rows option.

Set the condition: Rank is not equal to 1 OR Daily Progress is greater than or equal to 0.
OR
Use Power Query Formula 
Table.SelectRows(Source, each not ( [Rank] = 1 and [Daily Progress] < 0 ))

Please Try These and if this post helped please do give a kudos and accept this as a solution
Thanks In Advance

[AllanBerces]

Hi @Akash_Varuna thank you very much for the reply, work as i need.

[Akash_Varuna]

Sure No Problem please do give a kudos
Thanks In Advance