Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
pra137
Helper III
Helper III

Hold Time between 2 calls

Hello Guys,

I want to calculate the hold time between 2 calls of indiviual source on specific date i mean
suppoose source 602 call date is 1-9-2021  11:16:06 and his end time is 1-09-2021 11:16:37 and source 602 2nd call start at 1-9-2021 11:17:10 i have to calculate the hold time between 1-09-2021 11:16:37 and 1-9-2021 11:17:10 for source 602 and same for 603   please help how to do this
Thanks 
pra137

pra137_0-1636452854694.png

 

1 ACCEPTED SOLUTION

Hi @pra137 

You can try this code to achieve your goal.

Diff =
VAR _CurCallStart = 'Table'[Call Start]
VAR _LastCallEnd =
    CALCULATE (
        MAX ( 'Table'[Call End] ),
        FILTER (
            'Table',
            'Table'[Src] = EARLIER ( 'Table'[Src] )
                && 'Table'[Date] = EARLIER ( 'Table'[Date] )
                && 'Table'[Call End] < EARLIER ( 'Table'[Call End] )
        )
    )
VAR _TIMEDIFF = _CurCallStart - _LastCallEnd
RETURN
    IF ( _LastCallEnd = BLANK (), TIME ( 0, 0, 0 ), _TIMEDIFF )

Result is as below. Note to change the [Diff] column Data type to Time and Format to h:nn:ss.

1.png

Best Regards,
Rico Zhou

 

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

View solution in original post

7 REPLIES 7
VijayP
Super User
Super User

@pra137 
For A all Custom Values are duration between first call to last call

Try this solution and let me know if it helps!

Capture.PNG




Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
MY Blog || My YouTube Channel || Connect with me on Linkedin || My Latest Data Story - Ageing Analysis

Proud to be a Super User!


Thank sir but I have to calculate break time between 2 calls I mean 1st call end time is 11:16:37 should be subtract from start time of 2nd call eg 11:16:37-12:16:00

@pra137  any chance you can provide sample data and desired output clearly?

Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
My custom visualization projects
Plotting Live Sound: Viz1
Beautiful News:Viz1, Viz2, Viz3
Visual Capitalist: Working Hrs

I want  result like diff column in below pic

IMG-20211110-WA0000.jpg

Hi @pra137 

You can try this code to achieve your goal.

Diff =
VAR _CurCallStart = 'Table'[Call Start]
VAR _LastCallEnd =
    CALCULATE (
        MAX ( 'Table'[Call End] ),
        FILTER (
            'Table',
            'Table'[Src] = EARLIER ( 'Table'[Src] )
                && 'Table'[Date] = EARLIER ( 'Table'[Date] )
                && 'Table'[Call End] < EARLIER ( 'Table'[Call End] )
        )
    )
VAR _TIMEDIFF = _CurCallStart - _LastCallEnd
RETURN
    IF ( _LastCallEnd = BLANK (), TIME ( 0, 0, 0 ), _TIMEDIFF )

Result is as below. Note to change the [Diff] column Data type to Time and Format to h:nn:ss.

1.png

Best Regards,
Rico Zhou

 

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

VijayP
Super User
Super User

@pra137 

to get the result as below use this file

 

Capture.PNG




Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
MY Blog || My YouTube Channel || Connect with me on Linkedin || My Latest Data Story - Ageing Analysis

Proud to be a Super User!


Thanks but it shows time between call I want the hold time between 2 calls 

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.