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 Yacine2025
You could filter to get a table with just Log off details and a table with just Login in details. Sort them according to timestamp, index them and do a merge with the Index to get the respective Log off details.
This is assuming the data is clean and each log in will have a respective log off, vice versa.
Do give a kudos if this helps! 🙂
Thanks for your reply, i have a multiple login logout per session so for the moment its difficult to pair login logout and some sessions of users cross midnight.
Thanks