How to rows based on a certain condition?

[Anonymous]

I have a column in table named 'Count'. I want to only keep those records in the table where the value in count column is greater than 4. Idea behind this is, if the value in the count column is less than 4 then those records should not be involved in any further calculations that U shall be doing.

[v-stephen-msft · Accepted solution]

Hi @Anonymous ,

How about filtering in Power Query?

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Im getting below error -

[Vijay_A_Verma]

Use following type of construct where Source is your previous step

= Table.SelectRows(Source, each ([Count] > 4))