Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
eddya
Frequent Visitor

Total Time Spent Based On Scan Time

Hello,

 

I am trying to calculate the average time spent on packing orders per warehouse employee., based on the times they scan those shipments.

 

Here is sample data with my expected results:

 

OrderIDScan Date/TimeEmployee IDTotal Time Spent Per Day (Expected Result)
63009461/4/18 9:47 AM512452 Min
63016101/4/18 9:47 AM51245 
63016991/4/18 9:48 AM51245 
63021401/4/18 9:47 AM51245 
63025171/5/18 10:47 AM512456 min
63028841/5/18 10:49 AM51245 
63032511/5/18 10:52 AM51245 
63036181/5/18 10:53 AM51245 

 

Thank you for any assistance!

2 REPLIES 2
parry2k
Super User
Super User

@eddya your post doesn't explain what is the logic to calculate "avg time spent" There should be time start or something like that.



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

eddya
Frequent Visitor

I would like to calculate the average time spent on each order per person per day, assuming each scan is approx. 1 second. I am trying to divide the total duration by the # of orders, but I am not getting the expected results.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.