Forum Discussion
Distance between two adresses (no coordinates given)
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
2 Replies
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
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
