topic Re: Calculate Late Arrival Time of Employee in Report Server

Calculate Late Arrival Time of Employee

wasaprinters — Fri, 19 Jul 2024 06:18:17 GMT

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

Re: Calculate Late Arrival Time of Employee

fahadqadir3 — Fri, 19 Jul 2024 07:43:17 GMT

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

Re: Calculate Late Arrival Time of Employee

wasaprinters — Fri, 19 Jul 2024 08:22:14 GMT

Sir,

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

Re: Calculate Late Arrival Time of Employee

fahadqadir3 — Fri, 19 Jul 2024 11:07:41 GMT

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

Re: Calculate Late Arrival Time of Employee

wasaprinters — Fri, 19 Jul 2024 12:22:09 GMT

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