remove duplicate and keep the newest created

[Sofino]

Good morning all,
i have in data base SQL a table of products, with columns : Name of Product , Lot, Creation Date
in power bi, i need to remove duplicate products and keep only the last ones created (Creaion Date).

please can you help me?
thank you

 

[SpreadsheetTools]

Try using Table Design | Remove Duplicates command in your table. It gives you list of columns, that should be checked for duplicates. Leave only first column in this list and all duplicate values will be removed.

 

[GraH]

Create a function based on a simple example.
Filter it on latest date.

Convert to a function.

Now group by product the whole table, using aggregate all rows. Invoke the function on that column.
Expand the table.

Done.