Forum Discussion
Solved
Calculating Down Time Between Calls
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 ...
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/339586
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..