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
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 

 

 

 

 

    • Yacine2025's avatar
      Yacine2025
      Frequent Visitor
      1 year ago

      Hi ryan_mayu , sorry for the delay, i will try your solution tomorrow

       

      Thanks 

    • Yacine2025's avatar
      Yacine2025
      Frequent Visitor
      1 year ago

      Hi ryan_mayu ,

       

      Its not the expected result

       

      This is my goal, the session cross midnight

      Login

      2025-03-20 22:07

      Logoff

      2025-03-21 10:04

       

      Login

      2025-03-21 22:08

      Logoff

      2025-03-23 09:4

       

      Thanks in advance

      • ryan_mayu's avatar
        ryan_mayu
        Super User
        1 year ago

        Yacine2025 

        what do you mean cross the midnight? what's the time period for midnight?