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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

Top Solution Authors