Calculating distance between branches

[stathar0s]

Hi all!

I need your help!

I have a table with three columns: Branch_ID, Lat, Long and I want, when I select a branch (from the left table), to calculate the distance between this branch and all the other (in the right table).

Can anyone help me please!

Thank you!

[ShirinArshadnia · Accepted solution]

hi @stathar0s 

some of sites like below do this for you :

https://www.nhc.noaa.gov/gccalc.shtml

But for the formula 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 (6371 is Earth radius in km.)

this is useful too:

https://dataveld.com/2019/03/20/display-points-within-a-distance-radius-on-a-power-bi-map/