Find the call Duration for each coversation by writing a DAX formula

[vampirerulz600]

Hello,

I am currently working on a Call center Data and i have to find the call duration for each coversation using a DAX formula. The challenge here is there are multiple entries for each conversation with its relevant time stamps in the same column.

The table is as follows, I have a Convid and the CreatedTime for each stage of conversation. I need to find the total time taken on each Coversation and i have write a DAX such that i will get the time spent on each conversation. Also i need to find the Longest Call, Shortest Call and the Avg Call time. Please help.

 

[GraH]

Did you try

Call Duration:=max([CreatedTimeUTC])-min([CreatedTimeUTC])

 

[vampirerulz600]

Did you try

Call Duration:=max([CreatedTimeUTC])-min([CreatedTimeUTC])

i Have tried this but this is not returning the value for each coversation. i need to get table for each coversation

 

[GraH]

You did put convID in the rows section of the pivot with this measure?

 

[vampirerulz600]

You did put convID in the rows section of the pivot with this measure?

It is not a pivot table. It is actually a row in the dataset that i have uploaded to powerBI. and i would like to make a calculation of each call/conversation.

 

[GraH]

You say you want the result per call ID, then you are talking about a matrix visualization in PowerBI, somewhat the equivalent of a pivot in Excel.

 

[vampirerulz600]

You say you want the result per call ID, then you are talking about a matrix visualization in PowerBI, somewhat the equivalent of a pivot in Excel.

But, i suppose powerBI will not work as a pivot right.

 

[GraH]

Maybe I do misunderstand.
Did you try the matrix visualization in PowerBI?
Or do you only need min, max and average call duration?

 

[vampirerulz600]

Maybe I do misunderstand.
Did you try the matrix visualization in PowerBI?
Or do you only need min, max and average call duration?

I have tried Matrix but it does solve my requirement. So i need to create Measures for min max and avg call duration among the agents

 

[vampirerulz600]

I have tried Matrix but it does solve my requirement. So i need to create Measures for min max and avg call duration among the agents

I have tried Matrix but it does not* solve my requirement. So i need to create Measures for min max and avg call duration among the agents