Return all values if criteria match with comma sperated

[Anonymous]

I am trying to calulate but not getting result.

calculate(max(order_ID),filter(table,email=earlier(email)

[Anonymous]

working, Thank you sir😊

[amitchandak · Accepted solution]

@Anonymous , Try a new column like

concatenatex(filter(table, [email] =earlier([email])), [ID])