join generateseries by condition

[az38]

hello!

Ive got a

tablePeriod =  GENERATESERIES (
DATE ( 2018, 5, 1 ),
DATE ( 2018, 5, 3 ),
TIME ( 0, 30, 0 )
)

and Ive got a user's session log:

session_id; session_starttime; session_endtime

and i need to know count(session_id) for each value from tablePeriod that >=session_starttime and <= session_endtime

result is a tablePeriod from two columns: Period, CountSessions

Thank you!

[v-chuncz-msft · Accepted solution]

@az38,

You may use DAX below to add a calculated column.

Column =
COUNTROWS (
    FILTER (
        'session',
        'session'[session_starttime] <= tablePeriod[Value]
            && 'session'[session_endtime] >= tablePeriod[Value]
    )
)

[az38]

Thx, perfect!

[az38]

So, I want to define how many users were active on the server at each moment (each row) from the table tablePeriod