Hi coolioaus ,

To accomplish this in Power BI, we can create a solution using DAX calculations to count concurrent users based on their sign-in and sign-out times. Here’s a step-by-step guide:

1. Load the Data: First, import your data into Power BI. Ensure that the SignIn and SignOut columns are recognized as datetime data types.
2. Create a Time Table: To analyze the data by time intervals (e.g., every 15 minutes or every hour), create a separate time table. This table will allow us to check for users signed in during specific time intervals.
   • Go to the Modeling tab and select New Table.
   • Use the following DAX to create a time table that spans the day (modify the interval as needed):    TimeTable =
     GENERATE(
     CALENDAR(DATE(2024, 6, 11), DATE(2024, 6, 11)),
     VAR StartHour = TIME(0, 0, 0)
     VAR EndHour = TIME(23, 59, 59)
     RETURN GENERATESERIES(StartHour, EndHour, TIME(0, 15, 0))
     )

3. Create a Measure for Concurrent Sign-Ins: This measure will count how many users are signed in during each time interval.

   • Go to the Modeling tab and create a New Measure in your main data table with the following
     DAX:

     ConcurrentSignIns =
     
     VAR CurrentTime = SELECTEDVALUE(TimeTable[Time])
     
     RETURN
     
     COUNTROWS(
     
     FILTER(
     
     'YourDataTable',
     
     'YourDataTable'[SignIn] <= CurrentTime &&
     
     'YourDataTable'[SignOut] >= CurrentTime
     
     )
     
     )

   • Make sure to replace 'YourDataTable' with the name of your actual data table.

4. Visualize the Results: Create a line or area chart to show the count of concurrent users over time.

    

   1. Add TimeTable[Time] to the X-axis.

   2. Add the ConcurrentSignIns measure to the Y-axis.

5. Identify Peak Periods: To identify peak periods, you could create a new measure to find the maximum concurrent sign-ins in the day:                                                                                                 PeakConcurrentSignIns = MAXX(ALL(TimeTable), [ConcurrentSignIns])

This setup will allow you to see how the number of concurrent sign-ins varies over time and helps identify peak sign-in periods during the day

If I have resolved your question, please consider marking my post as a solution. Thank you!

Thanks for all the responses. I have a working solution and learnt a lot!

Hi,

Based on the description, you have solved the problem. If it's convenient, you can share the solution process, which can help others to better solve similar problems.

Best Regards,

Wisdom Wu