IF FORMULAR BASED ON DIFFERENT TABLES

[SN1900]

Hello all, 

Actually I am trying to create an if formular between two different tables.

So what I wanted to do is to compare the event date with the delivery appointment time. 

The relationship for both tables is the Shipment ID. 

The Shipment ID and the Delivery Appointment Time is in the  table OTM Shipment analysis. 

The Event time is in the table  OTM Event analysis.

I tried the formular with values from one table and then it is working.

(IF(OTM_EventStatus_Analysis[EVENT DATE TIME UTC]-OTM_EventStatus_Analysis[EVENT DATE TIME]>=0;FORMAT(OTM_EventStatus_Analysis[EVENT DATE TIME UTC]-OTM_EventStatus_Analysis[EVENT DATE TIME];"hh:mm:ss");FORMAT(-(OTM_EventStatus_Analysis[EVENT DATE TIME UTC]-OTM_EventStatus_Analysis[EVENT DATE TIME]);"-hh:mm:ss")))

But now I want to replace the "Event DATE TIME UTC "with the "DELIVERY APPOINTMENT TIME " but this is not working as the Delivery Appointment time is in another table. 

Any ideas how I can change the formular so that my formular is working . I have attached some screenshoots. 

Many thanks in advance and best regards 

Niclas 

[kentyler]

Do the 2 different tables have a relationship ?