Calculate duration between 2 rows

[Anonymous]

My data is showing calls, each event during the call is a new row. For example:

Call id	Queue	Event date	Event	Call transfer
1		2020-02-02 10:00:00	Menu
1	Sale	2020-02-02 10:02:00	Placed in queue
1	Sale	2020-02-02 10:03:30	Conversation	True
1	Help	2020-02-02 10:04:00	Placed in queue
1	Help	2020-02-02 10:05:00	Conversation
2		2020-02-03 10:00:00	Menu
2	Help	2020-02-03 10:05:00	Placed in queue
2	Help	2020-02-03 10:07:00	Conversation

I want to calculate the queue waiting time, both after the menu and after a transfer.

Total queuetime: 1:30 + 1:00 + 2:00 = 4:30 min
Average per call: 2 min 15 sec

I wish I could show but i have been trying but I don't know where to start or if it's even possible to do what I want. 

[Greg_Deckler · Accepted solution]

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

Should be able to use a variation of that.