Max Contact Date by Customer and Order Date

[Anonymous]

Hello All,

Please I need your Help urgently for this case :

I need to calculate the max contact date by customer ID and Order date, the condition is to have last contact Date before Order the order Date :

So Max Contact Date and Contact Date < Order Date as show on the result Table below :

Any help will be appreciated @amitchandak,@parry2k,@AlexisOlson,@bcdobbs

Thanks

[amitchandak · Accepted solution]

@Anonymous , a new column in sales table

maxx(filter(contract, contract[customer ID] = sales[customer ID] && contract[contrcat Date] <= sales[Order date]) ,contract[contrcat Date] )

[Anonymous]

Thanks @amitchandak