Forum Discussion

az38's avatar
az38
Community Champion
7 years ago
Solved

join generateseries by condition

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_e...
Need Help
  • v-chuncz-msft's avatar
    v-chuncz-msft
    7 years ago

    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's avatar
az38
Community Champion
7 years ago

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