Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All,
pls help me to solve this issue.
I have the below-listed attendance records of the user. And I need to calculate the hours spent in the office. For this, I took the lowest time as in time and the highest time as out time, by this way it worked fine but a few records created problems for said calculation.
Few employees worked from 8 am to the next day 1/ 2 am in the morning. and by this way, my logic failed because it took 1 am as the in time of the employee.
Is it possible to ignore the time which is between 12 am to 5 am? and assign the last out time as 11.59 pm for the previous day.
any other better way to handle it?
pls help .
thanks
Solved! Go to Solution.
apply a filter or add a conditional column to replace values.
apply a filter or add a conditional column to replace values.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.