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
