Calculating Down Time Between Calls

[sbendorf1787]

Hello, 

Hopefully someone can help with my current problem. I would like to calculate the Avg Down Time Between Calls by Employee for a KPI report. 

My dataset is a combination of csv. files that are weekly call logs that inclue numerous employees.  The csv. files are saved in a folder. The folder is then the source of my PowerBI query. 

Data set includes a start of call and call duration or talk time length but not end of call. Previously I have been sorting all of the data by employee and then calculating the end call time in excel. I can then subtract the calculated end time from the Next Calls Start Time to get a "Wrap Duration" or time between calls. 

 

Is this something I can do in Power BI? Any help is greatly appreciated! 

[sbendorf1787]

Thank you @Seward12533 and @Greg_Deckler for your replies! 

Greg it is very similar to your Mean Time Before Failure article. I think it is going to work with my dataset/problem. 

Thanks again for the help! And your article : ) 

[Greg_Deckler · Accepted solution]

Sounds very very similar to Mean Time Between Failure...

See my article on Mean Time Before Failure (MTBF) which uses EARLIER: http://community.powerbi.com/t5/Community-Blog/Mean-Time-Between-Failure-MTBF-and-Power-BI/ba-p/3395...

[Seward12533]

I would try to add a column that will calculate the MIN of all calls by that same person that start after the start time of the current slide. 

End Time = CALCULATE(MIN(table[Start Time]),table[Start Time]>[Start Time],table[AgentID=[AgentID])) 

or something like that..