Fabric is Generally Available. Browse Fabric Presentations. Work
towards your Fabric certification with the Cloud Skills Challenge.
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:
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
Go to Solution.
Hi @selinozdemirpbi ,
Please have a try.
VAR _a =
ALL ( 'Table' ),
[sender_id] = EARLIER ( 'Table'[receiver_id] )
&& [receiver_id] = EARLIER ( 'Table'[sender_id] )
&& [spesific_group] = "No"
MAX ( 'Table'[date-hour] ),
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 RegardsCommunity Support Team _ Rongtie
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
View solution in original post
Check out the November 2023 Power BI update to learn about new features.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.