Forum Discussion

Yacine2025's avatar
Yacine2025
Frequent Visitor
1 year ago
Solved

Need help

Hi everyone I'm New in power bi and i need help to resolve this case. I want to calculate session duration between login and logout for each user per login date knowing that status can contains mult...
Need Help
Yacine2025's avatar
Yacine2025
Frequent Visitor
1 year ago

Hi ryan_mayu 

I just ignore them in my post because the login is in the Last day but yes i want to do the same calculate for every user every day 

Thanks for your Quick reply

ryan_mayu's avatar
ryan_mayu
Super User
1 year ago

still not clear about the logic. could you pls update the sample data and expected output?

  • Yacine2025's avatar
    Yacine2025
    Frequent Visitor
    1 year ago

    Hi ryan_mayu 

    This is my row data

    UserName TimeStamp Status
    abc 2025-03-20 22:07 Login
    abc 2025-03-20 22:33 Logoff
    abc 2025-03-20 22:34 Login
    abc 2025-03-21 02:55 Logoff
    abc 2025-03-21 02:56 Login
    abc 2025-03-21 10:04 Logoff
    abc 2025-03-21 22:08 Login
    abc 2025-03-22 09:46 Logoff

    The expected result is like this

     

    LoginLogoff
    2025-03-20 22:072025-03-21 10:04
    2025-03-21 22:082025-03-23 09:4

    Its possible to have multiple login and logout for same user in the same session 

    Thanks