Reconciliation using a date/time range

[JohnM1985]

Hi,

I am attempting to perform a reconciliation using two systems.  Previously I have merged two tables with a Left Anti join kind, which results successfully in displaying only entries which do not exist in the second table.  

In this new attempt, an email is received, which generates a support ticket in another system and I am reconciling the two to ensure all emails have generated tickets.  I have a problem with finding a unique field to complete the join, which has left me using a string consisting of a date/time column concatenated to the senders name. 

My problem is, there is a delay in the ticket generation, so the date/time's don't match exactly, is there a way to create a range, say +5minutes, to enable the items to match?

If needed I'll try and do it with DAX but if I can do it within PQ would be preffered.  In an example

Email received:

21/02/2022 14:53:12 test@examplemail.com

would need to somehow match with the ticket created:

21/02/2022 14:55:34 test@examplemail.com

Any help would be appreciated!

Thanks

[JohnM1985]

Sorry^ just to confirm.  It's not the "add five minutes" formula I'm looking for, it's the way to be able to merge those two tables in the same way.

The time increase can vary, it's not constant for each email/ticket