Forum Discussion
Calculating distance between branches
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!
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/
1 Reply
- ShirinArshadnia
Helper II
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/