PartitionBy

[M_SBS_6]

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

[ryan_mayu · Accepted solution]

@M_SBS_6 

maybe you can try this

Test=calculate(min(test [earliest]),allexcept(test,test[id]))