Calculate Estimated Drive Time for a Delivery Rout...

DarinSpence · ‎06-14-2020

I have addresses and stop sequence, but have not found a method to calculate the estimated drive time from a warehouse to the 1st stop, then from the 1st to the 2nd, then 2nd to 3rd, and so on until a return to the warehouse.

mahoneypat · ‎06-14-2020

If your data doesn't inlcude a drive time for each start/stop address already, you can use a REST API to get drive times between addresses on each row. Please see this post with a detailed walk through of something similar. You would need to use a different Google Geo API and different url call, but same approach other than that.

https://community.powerbi.com/t5/Power-Query/Create-google-API-to-lookup-latitude-and-longitute-of-z...

If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.

Regards,

Pat

Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.

@mahoneypa HoosierBI on YouTube