cancel
Showing results for
Did you mean:
Frequent Visitor

## 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?

3 ACCEPTED SOLUTIONS

Accepted Solutions
Member

## Re: 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-h...

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

Moderator

## Re: Distance Calculation in Power BI

@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,

Super User

## Re: Distance Calculation in Power BI

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

Proud to be a Datanaut!

12 REPLIES 12
Member

## Re: 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-h...

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

Moderator

## Re: Distance Calculation in Power BI

@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,

Frequent Visitor

## Re: Distance Calculation in Power BI

How do I use Google Maps API in Power BI?

Super User

## Re: Distance Calculation in Power BI

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

Proud to be a Datanaut!

Highlighted
Regular Visitor

## Re: Distance Calculation in Power BI

This post is great but can anyone assist in calculating distance between two postcodes ?

Frequent Visitor

## Re: Distance Calculation in Power BI

Can I have the distances data exported out in Excel?

Frequent Visitor

## Re: Distance Calculation in Power BI

Fantastic blog, worked great for me

Member

## Re: Distance Calculation in Power BI

But how can we integrate it to Power bi?

Member

## Re: Distance Calculation in Power BI

But How to Integrate it into power bi?