Keep the Latest Record While Removing Duplicates @GoodlyChandeep
Keep the Latest Record While Removing Duplicates  @GoodlyChandeep
Uploaded November 2026 | Updated November 2026, 17 hours ago
By default, Remove Duplicates in Power Query keeps the first row it finds, which isn’t always the latest one. Here’s how to keep the most recent record for each ID instead.
Book Your Seat - courses.goodly.co.in/power-bi-ai-workshop

===== ONLINE COURSES =====
✔️ Grab My Power Query Book -
products.goodly.co.in/power-query-book

✔️ Master 'M' in Power Query -
products.goodly.co.in/learn-m-powerquery/?

✔️ Mastering DAX in Power BI -
products.goodly.co.in/learn-dax-powerbi

✔️ Power Query Course -
products.goodly.co.in/learn-power-query

✔️ Master Excel Step-by-Step-
products.goodly.co.in/learn-excel


===== LINKS 🔗 =====
Blog 📰 - goodly.co.in/blog
Corporate Training 👨‍🏫 - goodly.co.in/training
Need my help on a Project 💻- goodly.co.in/consulting


===== CONTACT 🌐 =====
Twitter - twitter.com/chandeep2786
LinkedIn - linkedin.com/in/chandeepchhabra
Email - goodly.wordpress@gmail.com


===== WHO AM I? =====
A lot of people think that my name is Goodly, it's NOT ;)
My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI.
Please browse around, you'll find a ton of interesting videos that I have created :) Cheers!
Keep the Latest Record While Removing DuplicatesHow Hidden Filters Break Your Power BI ReportThe Problem with AI Isn’t What You ThinkCreate a Chart with Just One Excel FormulaThe +1 Trick for Dates in Excel & Power BIWhat Does the “??” Really Do in Power Query M?How to Make Bulk Changes to Power BI Measures4 Essential Queries for Cleaner Power BI Models2 Awesome Power BI BooksPower BI’s Smartest FeatureSimple Power Query Hack to find age!How to Sync Slicers in Power BI
Goodly |

Keep the Latest Record While Removing Duplicates

SHARE TO X SHARE TO REDDIT SHARE TO FACEBOOK WALLPAPER