Forum Discussion
Solved
Removing duplicates by two columns of data
Hi All I have the folwing data, please see the example looking at the first four rows; I want to be able to remove the duplicate values of "W/Order" value WA00334 lusing "Op No" and "Date"...
Hi AMaxfield ,
you must sort by W/Order, Op No and date in descending order. Then use Table.Buffer to keep that sort order.
If you then remove dups on W/Order it will keep only the topmost row.
More reading here: Bug warning for Table.Sort and removing duplicates... - Microsoft Power BI Community
ImkeF
Community Champion
Community ChampionHi AMaxfield ,
you must sort by W/Order, Op No and date in descending order. Then use Table.Buffer to keep that sort order.
If you then remove dups on W/Order it will keep only the topmost row.
More reading here: Bug warning for Table.Sort and removing duplicates... - Microsoft Power BI Community