Overtime Calculation

[Anonymous]

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, and 6th day OT duration is getting clubbed with their 5th day working shift. I want to segregate the OT hours out of the total duration reflecting on single day.

[v-jingzhang]

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.

[VahidDM]

Hi @Anonymous 

Can you post sample data as text and expected output?
Not enough information to go on;

please see this post regarding How to Get Your Question Answered Quickly:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.
4. Relation between your tables

Appreciate your Kudos!!
LinkedIn:www.linkedin.com/in/vahid-dm/