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

Background Sometimes the performance of Power Query reading your source data is restricting your dashboard development.It takes too long to reload all your data.I Recently had a case where my source was a set of log files on an Azure Blob. While developing the dashboard I often times had a very bad internet connection. ThisRead more about Development vs Production (Data Source Filtering)[…]