Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

PowerBI maximum Concurrent Callers - Stats DAX

Hi please can you help, i have data that has a call start date and time   Time_of_connection Time_of_Disconnection   in Date/ Time format   I also have a User_ID field;   i need to calculate...
Need Help
v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
8 years ago

Hi Anonymous,

 

Rajendran's suggestion worked on my test. But need some little modification:

Count Measure =
CALCULATE (
    COUNT ( Table1[User_ID] ),
    FILTER (
        Table1,
        SELECTEDVALUE ( Date_Table[DateTime] ) >= Table1[Time_of_connection]
            && SELECTEDVALUE ( DateTime ) <= Table1[Time_of_Disconnection]
    )
)

 

Best regards,

Yuliana Gu

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    v-yulgu-msft

     

    thanks for that, what format should my date table be in for this to work?

     

    and if i need to do a visualisation that showed the number of concurrent calls taking place on an hour by hour basis from 9am until 6pm each day how could i do this?

     

    regards