Creating Late/Early/On-Time Measure for Employees

[Anonymous]

I am attempting to create a row in my Power BI report that allows managers to see if an employee is late, early, or on time. I completed a simple function that would say on-time if an employee clocked in at the exact start time, but there is also a 3-minute window before and after official start time that would also be considered on-time. Can I get some assistance with this? Here is what I had before I discovered the new information.

Status =

IF(

    'DUMP'[Punch Start] > 'DUMP'[Schedule Start],

    "Late",

    IF(

        'DUMP'[Punch Start] < 'DUMP'[Schedule Start],

        "Early",

        "On-Time"

        )

)

[TomasAndersson]

Hi!
You could try using TIME() 

Status =

IF(

    'DUMP'[Punch Start] > 'DUMP'[Schedule Start] + TIME(0, 3, 0),

    "Late",

    IF(

        'DUMP'[Punch Start] < 'DUMP'[Schedule Start] - TIME(0, 3, 0),

        "Early",

        "On-Time"

        )

)

Hope this helps!