Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

How to rows based on a certain condition?

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.

Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    3 years ago

    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.

3 Replies

  • Vijay_A_Verma's avatar
    Vijay_A_Verma
    Most Valuable Professional
    3 years ago

    Use following type of construct where Source is your previous step

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

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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's avatar
    Anonymous
    Not applicable
    3 years ago

    Im getting below error -