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...
- 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.
Hi ryan_mayu
There are users who have a working day from 8am to 5pm and others who start at 9pm and finish at 5am so I would like to determine the timestamps of the first login and the last logout to calculate the total duration per shif
thanksHi ryan_mayu , thank you so much its working
you are welcome