Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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!
Hi,
Share some data in a format that can be pasted in an MS Excel file and show the expected result.
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:
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
110 | |
107 | |
105 | |
89 | |
61 |
User | Count |
---|---|
168 | |
138 | |
134 | |
102 | |
86 |