Forum Discussion

timwilson's avatar
timwilson
Frequent Visitor
9 years ago
Solved

Counting concurrent calls

Hi,   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?  ...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi timwilson,

     

    Maybe you can try to use "countrows" function with calculate column to get the count of concurrent call.

     

    Sample:

    Concurrent Calls= COUNTROWS(FILTER('Table',[StartDate]>=EARLIER('Table'[StartDate])&&[EndDate]<=EARLIER('Table'[EndDate])))

     

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Generally, I will advice you to bing/google for the terms "dax events in progress"... and see where that gets you... :)