Forum Discussion
Solved
keep row based on a column for duplicate IDs in Power Query
Hi there, i have a data table with columns ServiceDirectionCode and DateTo I would like this data table to give me all the different ServiceDirectionCodes, and for the duplicate code...
Hi,
You may use the Group By feature and take the maximum of the DateTo column.
As Ashish_Mathur suggsted, just have your records group on Code level with max aggregation on Date column.
Regards,
Hi,
You may use the Group By feature and take the maximum of the DateTo column.