Calculate individual actions time duration for one unique queue

[odzelashvili1]

Hello PBI community 🙌

I'm building queue management report for my organization and I have some issues 🙂

My table looks like this:

where visit_key is unique queue number, and IDs are action IDs, which take this queue N.

I have calculated time from first entry (VISIT_CREATE) to first call and from entry to last action (VISIT_NOSHOW), I know that this queue was transferd 4 times and accordingly was called 4 times (5 in total, first in registration and 4 others).

What is my issue, I want to calculate all time duration from VISIT_TRANSFER_TO_QUEUE to VISIT_CALL.

any ideas? or do I explained my wish clearly?

thanks in advance 🙂

[v-xiaotang]

Hi @odzelashvili1 

Have you solved this problem? If yes, could you kindly accept the answer helpful as the solution (or kindly share your solution ). so the others can find it more quickly.
really appreciate!
Any question, please let me know. Looking forward to receiving your reply.

Best Regards,
Community Support Team _Tang

[odzelashvili1]

Sorry for so late answer, 

it doesnt worked 😞 and it is no longer important.

anyway, thanks for taking your time for my task 🙂

[v-xiaotang]

Hi @odzelashvili1 

you can try this

Diff_minute =
IF (
    MIN ( 'Table'[Column4] ) = "VISIT_TRANSFER_TO_QUEUE",
    DATEDIFF (
        MIN ( 'Table'[Column3] ),
        CALCULATE (
            MIN ( 'Table'[Column3] ),
            FILTER (
                ALL ( 'Table' ),
                'Table'[Column4] = "VISIT_CALL"
                    && 'Table'[Column3] > MIN ( 'Table'[Column3] )
            )
        ),
        MINUTE
    )
)

result

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[odzelashvili1]

Up,

really need some help 😞