Maximum Number of concurrent users

[Anonymous]

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!

[Ashish_Mathur]

Hi,

Share some data in a format that can be pasted in an MS Excel file and show the expected result.

[foodd]

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