Forum Discussion
Maximum Number of concurrent users
Hi all,
I want to write a Measure to get the Max concurrent users per day. My table schema is following:
- User | Startdatetime | Enddate | Endtime
For each day I want the maximum of concurrent users. So If users using the app in the same timerange (startdatetime-enddatetime), they counting as concurrent.
Hope this information is enough 🙂
Thanks!
2 Replies
- foodd
Community Champion
There are a number of variations on this including number of Tickets, number of Customers, etc.
A proper dedicated Dates table is a must.
Search through the Forum for patterns that would help.
These two threads would be of value:
- DAX measure to show the max customers count and the corresponding date by grouping of date field
- Open Tickets
- Ashish_Mathur
Super User
Hi,
Share some data in a format that can be pasted in an MS Excel file and show the expected result.
