Forum Discussion

SN1900's avatar
SN1900
Frequent Visitor
7 years ago

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...
Anonymous's avatar
Anonymous
Not applicable
7 years ago
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.
  • SN1900's avatar
    SN1900
    Frequent Visitor
    7 years ago

    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.