Chris Webb shows us how to speed up a query to get the maximum value in a column:
In part 1 of this series – which I strongly recommend you read before reading this post – I showed how removing columns from a table can make a dramatic improvement to the performance of certain transformations in Power Query. In this post I’ll show some tricks taught to me by Curt Hagenlocher of the dev team that can improve performance even more.
Click through for the trick and an explanation of when it works and when it doesn’t.