Time interval for unique records

[odzelashvili1]

Hello everybody and thanks in advance 🙂

I have table with 3 column:

visit_key - which is unique ID for unique visits

Process - where i see what happened, for e.i. Visit created, visit ended, Visit Transfered and so...

Time - In what time process happend 

visit_key	Process	Time
1	VISIT_CALL	16:08:56
1	VISIT_NEXT	16:08:56
1	VISIT_CREATE	16:08:56
1	VISIT_END	16:09:20
2	VISIT_CALL	16:09:50
2	VISIT_NEXT	16:09:50
2	VISIT_CREATE	16:09:50
2	VISIT_END_TRANSACTION	16:09:52
2	VISIT_TRANSFER_TO_USER_POOL	16:09:52

I need to write dax formula, where I can see what time does it took from VISIT_CREATE to VISIT_END for every unique Visit key.

I hope I eplained well what I need with my trouble english 🙂

any suggestions?

[Anonymous]

Hi @odzelashvili1 

I am glad that you found the solution . Please provide your method for the problem then consider Accept it as the solution to help the other members find it more quickly.

Best Regards

Community Support Team _ Ailsa Tao

[odzelashvili1 · Accepted solution]

For others:

https://community.powerbi.com/t5/Desktop/Time-duration-calculation-based-on-rows-with-unique-identif...

https://community.powerbi.com/t5/Desktop/DATEDIFF-between-Rows-and-GROUP-BY/td-p/309994

https://community.powerbi.com/t5/Desktop/Calculate-duration-based-on-dates-in-different-rows/m-p/588...

I found solutions 🙂