Distance between two adresses (no coordinates given)

[torbenHL]

Hey,

is there a way to calculate the linear distance between to adresses in Power BI (DAX)?

I do not have any coordinates to these adresses.

Sample data:

Adress 1: "Mittelweg 174, 20148 Hamburg"

Adress 2: "Reeperbahn 98, 20359 Hamburg"

Regards

Torben

[TeigeGao]

Hi @torbenHL ,

In PowerBI, it doesn't provide a method to calculate this, we can only handle it outside PowerBI, for example, we can use Python with google maps API to calculate it. For more information, please refer to this demo: https://www.youtube.com/watch?v=AE0jsd9DhQc

Best Regards,

Teige

[torbenHL]

Hi Teige,

thanks for your answer!

Is it possible to determine the coordinates to an adress? In that way i could calculate the bee line.

Example: 

given adress: Reeperbahn 98, 20359 Hamburg

Determination in Power BI (DAX, Bing Api, ...?) -> Coordinates: 53.549514, 9.960914

I would like to calculate that for multiple thousand adresses each day.

Thanks in advance

Torben