Forum Discussion
Remove all duplicate except first?
I've been banging my head on my desk/kitchen table as this should work but for some reason is eluding me. I have two columns, first is a list of IDs and the second is a date field. Is there a way...
you can do it in power query:
1) grouping by ID
2) leave the lines where the maximum date is indicated