Forum Discussion
Overtime Calculation
I need the Overtime hours calculation, the raw dump is in different time zone. I need segregation for 6th day OT. The issue is the 5th day login hours is refelcting on 6th day as per time zone, a...
Hi Anonymous
Without sample data we couldn't suggest more in details. One direction is to convert all datetime data into the same time zone. Both DAX and Power Query M can do that. When all data is in the same time zone, the calculation should get easier.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.