Forum Discussion
Anonymous
3 years agoNot applicable
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
- TomasAndersson
Solution Sage
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!