Forum Discussion
Distance Calculation in Power BI
do you have LAT and LONG? If yes you can do it with math:
if not you need to custom call Bing Maps or Google Maps APIs for that
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
do you have LAT and LONG? If yes you can do it with math:
if not you need to custom call Bing Maps or Google Maps APIs for that
How do I use Google Maps API in Power BI?
I did a blog post on calculating the direct line distance between two points in DAX
This post is great but can anyone assist in calculating distance between two postcodes ?
But How to Integrate it into power bi?
How about if you have 3 tables, one telling where from shipped, one telling where to shipped and third one which is having cities and latitube and longitudes? how to combine all of those.
