Select rows on minimum value in Power Query

Hi RobRoos 

You can use User Interface in Power Query Editor to get the same result. Steps are:

1. Select Transform > Group By, group on LDMserver column and perform two actions: 

Min Ranking: Min on LDMranking

All Data: All Rows

2. Expand All Data column

3. Select Add Column > Conditional Column. If LDMranking equals to Min Ranking, it returns 1. Otherwise it returns 0. 

4. Filter IsMinRanking? column to keep rows whose value is 1. 

5. Remove IsMinRanking? and Min Ranking columns. 

Result

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.