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, 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.

2 Replies

  • VahidDM's avatar
    VahidDM
    Super User
    4 years ago

    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/

  • v-jingzhang's avatar
    v-jingzhang
    Community 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.