Filter one field based on another

[paulo_silva]

I have two tables, customer orders 

and opened emails

What I need is to find the last time a customer clicked an email before making a purchase. Something like this:

How do I do this?

[BrunPierre]

One way is to use FirstSortedValue() in a chart expression like this:

=FirstSortedValue([Click Time],-[Click Time])

[paulo_silva]

Thanks for the reply, @BrunPierre !

That doesn't do it, since I might have multiple orders for one client. I need to find the last click time for every order. Putting it another way, I need to find the time of the last email the client clicked before the order. Any values here where [Click Time] are greater than [Order Time] are not correct. 

I'm trying 

=FirstSortedValue({$<[Click Time] = {"<=$([Order Time])"}>}[Click Time],-[Click Time])

But that's not doing it either.

[paulo_silva · Accepted solution]

I managed to figure out what works here. You can do

max(if([Click Time]<[Order Time],[Click Time]))