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!