cancel
Showing results for
Did you mean:

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

New Member

## Average answer time for chat messages

Hi, i want to find average answer time for a spesific group.

Receivers may be change, i should examine all conversations seperately.

Table is like that:

 sender_id receiver_id date-hour spesific_group 2 1 01.01.2022 09:00 No 1 2 01.01.2022 09.10 Yes 1 3 02.01.2022 10:00 Yes 3 1 02.01.2022 13.00 No 1 3 02.01.2022 13.30 Yes 5 6 02.02.2022 15.00 Yes 6 5 02.02.2022 15.30 No 5 6 02.02.2022 15.40 Yes

for ex, sender 1's average answer time is 10 minutes from the conversation with 2 and 30 minutes from the conversation with 3.

It means that average answer time for 1 is 20 minutes.

And for number 5, average time is 10 minutes.

I hope I have been able to explain, thank you

If it's too complicated I'm open for another approximate solutions

1 ACCEPTED SOLUTION
Community Support

``````Measure =
VAR _a =
SUMMARIZE (
'Table',
'Table'[sender_id],
"Time",
DATEDIFF (
MAXX (
FILTER (
ALL ( 'Table' ),
[sender_id] = EARLIER ( 'Table'[receiver_id] )
&& [receiver_id] = EARLIER ( 'Table'[sender_id] )
&& [spesific_group] = "No"
),
[date-hour]
),
MAX ( 'Table'[date-hour] ),
MINUTE
)
)
RETURN
AVERAGEX ( _a, [Time] )
``````

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards
Community Support Team _ Rongtie

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

Community Support

``````Measure =
VAR _a =
SUMMARIZE (
'Table',
'Table'[sender_id],
"Time",
DATEDIFF (
MAXX (
FILTER (
ALL ( 'Table' ),
[sender_id] = EARLIER ( 'Table'[receiver_id] )
&& [receiver_id] = EARLIER ( 'Table'[sender_id] )
&& [spesific_group] = "No"
),
[date-hour]
),
MAX ( 'Table'[date-hour] ),
MINUTE
)
)
RETURN
AVERAGEX ( _a, [Time] )
``````

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards
Community Support Team _ Rongtie

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