Forum Discussion
Get chart using DAX
Hi Laur1987
Thank you for the clarifications. Please refer to the sample file with the solution
Count = VAR CurrentJoinTime = MAX ( '81099122685_-_Attendee_Report'[Join Time] ) RETURN CALCULATE ( SUMX ( '81099122685_-_Attendee_Report', VAR JoinTime = '81099122685_-_Attendee_Report'[Join Time] VAR LeaveTime = '81099122685_-_Attendee_Report'[Leave Time] RETURN IF ( CurrentJoinTime >= JoinTime && CurrentJoinTime <= LeaveTime, 1, 0 ) ), REMOVEFILTERS( '81099122685_-_Attendee_Report' ), '81099122685_-_Attendee_Report'[Join Time] <= CurrentJoinTime )
I need to count how many users are logged in by intervals of time. I supposed that User A joined at 14:04. User B at 14:05, User C joined at 14:10. That means that in my chart I will have: at 14:04 I have one user online, at :14:05 I have 2 users online, (at 14:10 I will have 8 users online... Because I add the users that are already online before 14:10 for example.)
See the below example from Excel: I used a lot of formulas and sheets to have this result.
tamerj1Thanks!
Community ChampionHi Laur1987
Thank you for the clarifications. Please refer to the sample file with the solution
Count =
VAR CurrentJoinTime = MAX ( '81099122685_-_Attendee_Report'[Join Time] )
RETURN
CALCULATE (
SUMX (
'81099122685_-_Attendee_Report',
VAR JoinTime = '81099122685_-_Attendee_Report'[Join Time]
VAR LeaveTime = '81099122685_-_Attendee_Report'[Leave Time]
RETURN
IF (
CurrentJoinTime >= JoinTime && CurrentJoinTime <= LeaveTime,
1,
0
)
),
REMOVEFILTERS( '81099122685_-_Attendee_Report' ),
'81099122685_-_Attendee_Report'[Join Time] <= CurrentJoinTime
)Many thanks! You saved me! 😄 Can you tell how I can do to shrink time in chart? In this moment I see at half hour. I want to see at 5-10 minute the chart. tamerj1