calculation of waiting time using 4 columns

[Anonymous]

Hiii

i want to calculate waiting time ,i need to substract 4 columns called disconnect time, connect time, Hold time, Talk duration 

i have applied this formula in excel previously 

=[@[Disconnect Time]]-[@[Connect Time]]-[@[Hold Time]]-[@[Talk Duration]]

how can i calculate in power bi

[harshnathani · Accepted solution]

HI @Anonymous ,

Incase you want to create a Calculated Column

Column =
'Table'[Disconnect Time] - 'Table'[Connect Time] - 'Table'[Hold Time] - 'Table'[Talk Duration]

Incase you want to create a Measure

Column =
MAX ( 'Table'[Disconnect Time] )
    - MAX ( 'Table'[Connect Time] )
    - MAX ( 'Table'[Hold Time] )
    - MAX ( 'Table'[Talk Duration] )

Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

[ryan_mayu]

@Anonymous 

do you want to create a measure or a column?

I think you can create a column just using the same formula in the excel.

[Arklur]

WaitingTime =
VAR vDisconnectTime = CALCULATE ( SUM ( Data[Disconnect Time] ) )
VAR vConnectTime = CALCULATE ( SUM ( Data[Connect Time] ) )
VAR vHoldTime = CALCULATE ( SUM ( Data[Hold Time] ) )
VAR vTalkTime = CALCULATE ( SUM ( Data[Talk Time] ) )
RETURN
    vDisconnectTime - (vConnectTime + vHoldTime + vTalkTime)

EDIT:

Although, this performs better and still readable:

WaitingTime = 
CALCULATE ( 
    SUMX (
        Data,
        Data[DisconnectTime] - ( Data[ConnectTime] + Data[HoldTime] + Data[TalkTime] )
    )
)