Forum Discussion
Anonymous
4 years agoNot applicable
Volume handled between login and logout time
There are multiple day and night shifts in which people are working. I want to calculate total volume(content) handled between login time and logout time.
Login time is calculated based on first content person worked in day/night.
Logout time is calculated based on last content person worked during his shift.
I have timestamp column having distinct value when person worked on content.
Timestamp, login and logout are of Date time data type.
I am not able to calculate total volume when shifts ends on next day as I am unable find timestamp values for previous day.
#power bi #desktop
1 Reply
- rajkmr106New Member
You need to first calculate the shift time, Then you able to calculate the volume