PartitionBy

Hi, I have grouped my table to show and show the earliest and latest date as a customer. I am needing to identify the names by ID which customers regardless of product has become a new customer in 2024.

Example data

Id name product earliest        Test 

1 Kevin.   AA.        28/07/23.  28/07/23

1 Kevin.   BB.         27/02/24. 28/07/23

i hoped the logic below would create the test column above but I get an error. 

Test= year(
Minx(
Index(1,
Invest,
Orderby(test[earliest], asc),
,
Partitionby test[id],
Matchby test[id], test[product], test [earliest])
),
Test[earliest]
)
)

I get an error despite of matchby columns bring specified, duplicated rows are encountered in INDEXs relation parameter. This is not allowed