Choice row in table

[Carlo1975]

Hi, I have a table with some columns but I have to concentate only on this 3:

Position	Id Product	Start Date
1	125	06/05/2014
2	130	02/08/2018
3	140	01/09/2020
3	141	03/05/2015
4	659	04/05/2020
5	458	01/05/2017
6	850	08/08/2018
6	253	06/09/2017

When the ID Position repeats itself I have to choice the Product Id who have the most recently date. and so, For the ID Position 3 the Product ID 140 and For the ID Position 6 the Product ID 850. In my Matrix Table I will have:

Position	Id Product	Start Date
1	125	06/05/2014
2	130	02/08/2018
3	140	01/09/2020
4	659	04/05/2020
5	458	01/05/2017
6	850	08/08/2018

Is it possible to do it with DAX? I saw in the past that in powr quer is very very slow.

thank you

[amitchandak]

@Carlo1975 , for start date take max

for product use this measure

Last Product = calculate(max(Table[Product]), filter(Table, Table[Start Date] = calculate(max(Table[Start Date]), allexcept(Table, Table[Position Id]))) )