Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Creating Late/Early/On-Time Measure for Employees

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"
        )
)

1 Reply

  • 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!