Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
Hi Everyone there,
Can somehelp me to solve the below mentioned issue?
I need to calculate Time [ Hours or Minutes ] from order created to 1st Deliver?
Are those dates in the same line?
If yes, create a DAX Measure like this:
Diff = DATEDIFF(MAX(Date1), MAX(Date2), HOURS)
Thank you for your feedback
Ive data where Delivered dates and order dates are stored.
Required
Hours or minutes from Order Created to Deliver 1st Order and than 2nd to 3rd and onwards by the
Ive Order date column + Deliver date column + partner name as well
Expected Results
Delivered By Partner | #Avg ord - del 1st Order | Avg Hours # |
East Partner | 2.33 | 3 |
West Partner | 4.00 | 1 |
Grand Total | 2.75 | 4 |
I want to calculate time taken by a partner to deliver 1st order every day?
User | Count |
---|---|
97 | |
67 | |
57 | |
47 | |
46 |