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
