Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

If Statement with Date and Time Format

Hello,    Need Help with an If statement that includes all of the following factors below. I want to calculate the following   If the Driver pick up (Time) is 15 mins <= to the scheduled arrival ...
Need Help
  • v-xulin-mstf's avatar
    v-xulin-mstf
    5 years ago

    Hi Anonymous,

     

    Try measure as:

    Measure = 
IF(
    DATEDIFF(MAX('Table'[Driver Pick up Time]),MAX('Table'[Schedule Arrival Time]),MINUTE)<=15 && DATEDIFF(MAX('Table'[Driver Pick up Time]),MAX('Table'[Schedule Arrival Time]),MINUTE)>=0,
    "on time",
    IF(
        DATEDIFF(MAX('Table'[Driver Pick up Time]),MAX('Table'[Schedule Arrival Time]),MINUTE)>=16,
        "Early",
        "Late"
    )
)

    Here is the output:

    The pbix file is attached.

     

    Best Regards,
    Link

     

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Anonymous , Try a new column like

 

new column =
var _diff = datediff([Driver pick up time ],[scheduled arrival time], minute)
return
switch(true() ,
_diff <0 , "Late",
_diff <=15 , "On Time",
"Early"
)