Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
torbenHL
Frequent Visitor

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 2
TeigeGao
Solution Sage
Solution Sage

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

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.