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...
Marek VavrovicApr 30, 20223 minExcelCustomer Retention & Cohort AnalysisCustomer cohort analysis is beneficial in marketing and business use cases. For subscription & non-subscription businesses. Companies use...