Need help writing a DAX formula showing if one column is >= another, it shows as late

[Anonymous]

Hello everyone! 

I'm fairly new to Power BI and DAX, and my google searching hasn't been very successful. 

I have these two columns that I need to write a DAX measure for. The Arrival shows when a driver got to his pick up location, and the depart is when he left. I need to write a formula showing that if a driver left 45 minutes or after his arrival to the pick up, it is shows as late. 

Thank you in advance, and I look forward to learning something! 

[AlB · Accepted solution]

Hi @Anonymous 

You talk aoubt DAX but seem to be showing a table in PQ. 

If it's DAX you want, create this calculated column:

New column =
IF (
     ( Table1[edi_pckp_arrival] - Table1[edi_depart_pickup] ) * 24 * 60 >= 45,
    "Late",
    "On time"
)

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers