I started researching this question when I came at a great post of Rick de Groot at ExcelGorilla.
So instead of posting, here is the link: How to Group By Maximum Value using Table.Max – Power Query #3
How to get the values in a row from the last update date grouped by a label?