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
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi  RajP  ,

Here are the steps you can follow：

1. Create calculated column.

Take Time =
IF(
[Fin. Dat]=BLANK(),IF([Arrival]=BLANK(),[Desp.],[Arr.]),[Fin.])
Take Time =
IF(
[Fin. Dat]=BLANK(),IF([Arrival]=BLANK(),[Desp.],[Arr.]),[Fin.])
TIME =
IF(
    [Desp. Da]=BLANK(),BLANK(),
IF(
WEEKDAY([Call Date])=4&&WEEKDAY([Take Date])=7&&WEEKNUM([Call Date])=WEEKNUM([Take Date]),TIME(2,0,0),[Take Time]-[Call Time]))

2. Result.

 

 

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

RajP's avatar
RajP
Frequent Visitor
5 years ago

Thank you Liu Yang, unfortunately this doesn't resolve my issue. I need to compare Call Date and Time with 'Now()' time, so I can determine where we haven't met SLA, taking into account business hours.