• 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

Add the line:
Code:
= Table.SelectRows(#"Changed Type", each [Date] > List.Min(#"Changed Type"[Date]))
 
Back
Top