Forum Discussion
IF Formular ( 2 Tables)
Hi all, Actually I am starting to create my first Power BI Reports and therefore I need an if formular. Unfortunately it is not working as I can only select the data from one of the two tables...
With the info you've given it's not possible to tell you what to do. We have to know the structure of your model first of all...
Best
D.
Best
D.
Hi darlove,
please find attached some screenshoots
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 coming from the table OTM Shipment analysis.
The Event time is coming from the OTM Event analysis.
I tried the formular with time 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.