Forum Discussion

selinozdemirpbi's avatar
selinozdemirpbi
New Member
3 years ago
Solved

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 ...
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi selinozdemirpbi ,

    Please have a try.

    Measure =
    VAR _a =
        SUMMARIZE (
            'Table',
            'Table'[sender_id],
            'Table'[receiver_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] )
    

     

    How to Get Your Question Answered Quickly 

     

    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.