Forum Discussion
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...
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
what do you mean cross the midnight? what's the time period for midnight?
- The user starts at 22h07 and finish at 10h4 am the day after in this case i need to calculate the duration of his session between 22h07 and 10h4am knowing that in others cases it may have multiple login and logoff that i want to ignore.
Thanks
what i mean is the standard creteria for all the situaion. what if logout at 9 am and login at 10 am again? what if logout at 10 am and login at 11 am? What I want is the start time and end time of midnight.