Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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...
v-jingzhang's avatar
v-jingzhang
Icon for Community Support rankCommunity Support
4 years ago

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.