Forum Discussion
Calculating distance between branches
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/
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/