Delivery performance
Dear All, I have found the networking days between our confirmed delivery date and shipment date. If we ship according to what we have confirmed to the customer, the value will be 2. Now I ne...
Forum Discussion
Create a measure like this :
Measure =
VAR _SUM=0-SUMX('Table',[NetworkingDays])
var _mindate=MIN('Table'[Shipment_Date])
var _maxdate=MAX('Table'[Shipment_Date])
var _diff=DAY(_maxdate)-DAY(_mindate)-1
return _SUM/_diffThen you will get a result like below :
NetworkingDays is a measure .
Best Regards,
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks!!