cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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

1 ACCEPTED SOLUTION
Community Support

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.

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.

7 REPLIES 7
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!

MY Blog || My YouTube Channel || Connect with me on Linkedin || My Latest Data Story - Ageing Analysis

Proud to be a Super User!

Helper III

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

Super User

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

Proud to be a Super User!
My custom visualization projects
Plotting Live Sound: Viz1
Beautiful News:Viz1, Viz2, Viz3
Visual Capitalist: Working Hrs
Helper III

I want  result like diff column in below pic

Community Support

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.

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.

Super User

to get the result as below use this file

MY Blog || My YouTube Channel || Connect with me on Linkedin || My Latest Data Story - Ageing Analysis

Proud to be a Super User!

Helper III

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

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.