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]
    )
)
v-chuncz-msft's avatar
v-chuncz-msft
Community Support
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

Thx, perfect!