Distance between 2 stops

[kaym]

Hello,

I have some logistics data where there are shipment number and for each shipment there are a number of stops. Typically, a shipment goes from stop 1 to stop 2. But for some shipments there are more than 2 stops i.e. stop 1,stop 2, stop 3, stop 4 etc.

I need to create a new column "distance" that shows the distance between stops in a shipment. I have no idea how to do it. I did create columns for latitiude and longitiude using google API. This is how my data looks:

The distance column should show the distance of a stop from the stop right above it for each shipment. Any help or guidance would be really appreciated. Thank you!

[dufoq3]

Hi @kaym,

this topic could help you or maybe directly @AlienSx.

[lbendlin]

That's the Great Circle distance. It is meaningless for logistics.

[lbendlin]

I doubt that you want to calculate the Great Circle Distance ("as the crow flies").  There are no interfaces in Power BI to routing APIs.  You would have to calculate that elsewhere, taking into account local conditions (construction, road closures etc).