Forum Discussion
Post PatronGrouping Similar Data Entries but Using Latest Record Only
You can use Power Query:
Group By the columns with the similar values in your example Select columns for Value A, B and C then in the Transform tab > Group By. Then in the section below to add more columns, select Max, then choose the Date column.
Alternatively you could use 'remove duplicates' after doing a sort and table buffer, but I think Group by is more performant (not sure though).
Community ChampionYou can use Power Query:
Group By the columns with the similar values in your example Select columns for Value A, B and C then in the Transform tab > Group By. Then in the section below to add more columns, select Max, then choose the Date column.
Alternatively you could use 'remove duplicates' after doing a sort and table buffer, but I think Group by is more performant (not sure though).
Post PatronThanks AllisonKennedy. Works perfectly!