I need to count the number of concurrent calls.
I have a start datetime of each call and an end datetime of each call, anyone have any ideas on counting the amount of concurrent calls?
Go to Solution.
Maybe you can try to use "countrows" function with calculate column to get the count of concurrent call.
Concurrent Calls= COUNTROWS(FILTER('Table',[StartDate]>=EARLIER('Table'[StartDate])&&[EndDate]<=EARLIER('Table'[EndDate])))
View solution in original post
Generally, I will advice you to bing/google for the terms "dax events in progress"... and see where that gets you... 🙂
is it possible to further filter this by user? to count the concurent events of each user, not of everyone.
Join us in the third Triple A event!
It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.
Make sure you didn't miss any of the things that happened in the community in January!