Time interval for unique records

Question

Hello everybody and thanks in advance 🙂&nbsp;I have table with 3 column:visit_key - which is unique ID for unique visitsProcess - where i see what happened, for e.i. Visit created, visit ended, Visit Transfered and so...Time - In what time process happend&nbsp;&nbsp;visit_keyProcessTime1VISIT_CALL16:08:561VISIT_NEXT16:08:561VISIT_CREATE16:08:561VISIT_END16:09:202VISIT_CALL16:09:502VISIT_NEXT16:09:502VISIT_CREATE16:09:502VISIT_END_TRANSACTION16:09:522VISIT_TRANSFER_TO_USER_POOL16:09:52&nbsp;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.&nbsp;I hope I eplained well what I need with my trouble english 🙂&nbsp;any suggestions?&nbsp;&nbsp;

odzelashvili1 · Accepted Answer

For others:&nbsp;https://community.powerbi.com/t5/Desktop/Time-duration-calculation-based-on-rows-with-unique-identifiers/m-p/436990&nbsp;https://community.powerbi.com/t5/Desktop/DATEDIFF-between-Rows-and-GROUP-BY/td-p/309994&nbsp;https://community.powerbi.com/t5/Desktop/Calculate-duration-based-on-dates-in-different-rows/m-p/58886#M24122&nbsp;I found solutions 🙂

Forum Discussion

Time interval for unique records

2 Replies

Related content

Unique records in SELECTCOLUMNS

Unique records

Counting Non-Blank Records

Sorting Records

Unique Count in Row convert

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