Forum Discussion

guy_sextus's avatar
guy_sextus
New Member
9 years ago

Calculating Over Time based on Stop & Start Time

Hi,

        I'm a new user to Power BI so please forgive my lack of experience with this question.

 

My Question: I have to fields in a record - Start Time and Stop time and I want to calculate which portion of the time is over time and which is normal time.

 

Over Time = any time between 5.00pm and 7.00am.

Normal time = anytime between 7:00am and 5.00pm.

 

e.g. Start Time is 6.00am and Finish time is 8.00am. The resultant needs to 1 hour Over time and 1 normal time for this record. How does Power BI do this?

Need Help

2 Replies

  • vanessafvg's avatar
    vanessafvg
    Community Champion
    9 years ago

    guy_sextus is it possible to post a screenshot of what your data looks like?  and if you have more than one table a picture of your relationships

    • guy_sextus's avatar
      guy_sextus
      New Member
      9 years ago

      Hi,

              The data looks like this

       

      Table: Calendar Entry

      Field: StartTime        Data: 12/07/2017 06:00

      Field: FinishTime       Data: 12/07/2017 08:00

      EmployeeID             Data: 06

       

      The only relationship (of relevance to this query) is a link to the Employee Table for the employee data.