cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
odzelashvili1
Helper I
Helper I

Calculate individual actions time duration for one unique queue

Hello PBI community 🙌

 

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

 

My table looks like this:

odzelashvili1_0-1629961973585.png

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 🙂

4 REPLIES 4
v-xiaotang
Community Support
Community Support

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

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
Community Support
Community Support

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

vxiaotang_0-1630378156274.png

 

 

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
Helper I
Helper I

Up,

 

really need some help 😞

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!