Volume handled between login and logout time

[Snapdrag]

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

[rajkmr106]

You need to first calculate the shift time, Then you able to calculate the volume