Marek VavrovicMay 3, 20222 minExcelPower Query : Get the last / max record from a subsetSample data: I have a table where 1 Order Number has multiple record in that. I want to retrieve just the most recent one. 1. Group by...
Marek VavrovicMay 3, 20222 minExcelPower Query: Normalizing denormalized tableSample data: I have this Denormalized table, and I want to put the table into 3rd normal form. Load table into Power Query 2. Duplicate...
