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  ,

If you want to get now, you can directly change the time column to this form:

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),NOW()-[Call Time]))

Compare the calculated time with your index

 

 

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.