Forum Discussion

torbenHL's avatar
torbenHL
Frequent Visitor
7 years ago

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 Ham...
Need Help
TeigeGao's avatar
TeigeGao
Solution Sage
7 years ago

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's avatar
    torbenHL
    Frequent Visitor
    7 years ago

    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