Forum Discussion
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 clocke...
TomasAndersson
Solution Sage
Solution SageHi!
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!
Hope this helps!