• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How to remove rows with the lowest value in a column

Kelly A

Member
How to remove rows with the lowest values in a column. There will be several rows with the same lowest values which need to be deleted every week when there is new/refreshed data. I don't see a filter or group by to handle this. In the attached example, I would like to remove all the rows which contain the value 20230501 (this will change every week so need to filter out the lowest values in the column).
 

Attachments

  • Remove Rows Data Sample.xlsx
    18.1 KB · Views: 3
Add the line:
Code:
= Table.SelectRows(#"Changed Type", each [Date] > List.Min(#"Changed Type"[Date]))
 
Back
Top