Distance Calculation in Power BI

do you have LAT and LONG? If yes you can do it with math:

https://stackoverflow.com/questions/27928/calculate-distance-between-two-latitude-longitude-points-haversine-formula

if not you need to custom call Bing Maps or Google Maps APIs for that

Anam

You need Latitude and Longitude to calculate the distance between two locations with following formula:

=acos(sin(lat1)*sin(lat2)+cos(lat1)*cos(lat2)*cos(lon2-lon1))*6371

ps: 6371 is Earth radius in km.

You can achieve it via either Power Query or DAX method.

Or you can use Google Map API as cs_skit suggested.

Regards,

I did a blog post on calculating the direct line distance between two points in DAX

http://radacad.com/dynamic-distances-in-power-bi