Calculate Late Arrival Time of Employee

[wasaprinters]

Respected All,

With referene of screenshot of my Colomns, Our Company Time is 10 AM is Checkin and 7 Pm is Check Out, While Colums [dali_time] is a actual time of Employee arrival and leave.. First of All i want to seperate the time from 1 colums to 2 colums i.e. Time in Actual and Time out Actual then after i want a new colums which show Late arrival of Employee or Leave early employee with another column late mintues or hours calculation of employee 

Thanks in Advance 

[fahadqadir3]

@wasaprinters  First you need to apply PIVOT functionality on "dali_time" and "Check in out" column to get the 2 separate columns for check in and check out time. Please review the attached following screenshots;

Now you have 2 separate columns, now write a calculated Column in DAX to find out Late or on time:

CheckoutStatus = 
VAR CheckOutTime = 'Table'[Check out]
VAR TimeOut = [Time Out]
RETURN 
IF(
CheckOutTime = TimeOut, 
"On time",
IF(
CheckOutTime < TimeOut,
"Early",
"Late"
)
)

@wasaprinters  Hope it works.

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!! 

[wasaprinters]

Sir,

Now it bacame like this,, but i want as you have shared the screenshot in two colums check in and check out 

[fahadqadir3]

@wasaprinters Please share your previous step screenshot. You just need to select 2 Columns.

1st column with IN Out e.g: Check IN and Check Out

2nd Column: Time

[wasaprinters]

Its Generating error Expression.Error: We cannot convert the value null to type Text.
Details:
Value=
Type=[Type]