Forum Discussion

RajP's avatar
RajP
Frequent Visitor
5 years ago

Elapsed Time

Hi, I'm fairly new to Power BI, and i'm trying to calculate the elapsed time between when the call comes in to the current time / time responded, taking into account business hours and weekends.   ...
Need Help
RajP's avatar
RajP
Frequent Visitor
5 years ago

Hi Pragati,

 

Thank you for coming back to me. Please see sample data below:

Hopefully you can see the data, but basically it shows the call date and call time, and i need to identify any calls that have not been responded to within 4 working hours. I do have a businesshour table that shows Start of the day (9am) and End (5pm), along with a calendar table as below:

 

 

Please let me know if you require any more info?

 

  • Pragati11's avatar
    Pragati11
    Super User
    5 years ago

    Hi RajP ,

     

    Can you share the data in a file please? Typing data in Power BI is cumbersome.

     

    Thanks,

    Pragati

    • RajP's avatar
      RajP
      Frequent Visitor
      5 years ago

      ok, will be with you shortly

      • RajP's avatar
        RajP
        Frequent Visitor
        5 years ago

        Sorry Pragati, I'm struggling to attach the file, I've tried attaching an Excel sheet, CSV and the power BI file and it says that the file type is not supported, any ideas?