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

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
eddya
Frequent Visitor

Average Time Spent Per Order By Month

I am currently measuring the performance of our various warehouse employees by calculating minutes spent per order per day using this MEASURE:

 

TimeSpentPerOrder = CALCULATE(DIVIDE(DATEDIFF(MIN(ShipVerifiedReport[Scan Date]),MAX(ShipVerifiedReport[Scan Date]),MINUTE),[NumberOfOrdersProcessed]))

Here is a sample of my data:

 

Capture.PNG

 

And here is a sample of the results from the above formula:

 

Capture2.PNG

 

Basically, I'd like to divide the [Distinctcount] number of working days by the sum of minutes per order. Since the minutes per order is calculated using a measure, I am unable to do so very easily. Any assistance is appreciated on the matter.

 

Thank you!

 

1 ACCEPTED SOLUTION
eddya
Frequent Visitor

Solved using this thread.

 

Thanks!

View solution in original post

1 REPLY 1
eddya
Frequent Visitor

Solved using this thread.

 

Thanks!

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.