Forum Discussion
Distance Calculation in Power BI
Hey,
I wanted to know that once I have plotted several locations on a map in Power BI, how can I calculate the distance between any two locations?
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
15 Replies
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,
Can I have the distances data exported out in Excel?
Cant You just do euclidean distance -> sqrt((lat1-lat2)^2+(lon1-lon2)^2)*110.574 km ?
Also Why do wee need to get geocode from other sources like Google ( paid ), when power BI does locate cities on the map - therefore it could just give us direct answer regarding the longitude and latitude of certain city.
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
But How to Integrate it into power bi?
But how can we integrate it to Power bi?
