Calculating distance between branches

stathar0s — Tue, 18 Apr 2023 05:37:51 GMT

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!

Re: Calculating distance between branches

ShirinArshadnia — Tue, 18 Apr 2023 06:14:32 GMT

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/

topic Calculating distance between branches in DAX Commands and Tips

Calculating distance between branches

Re: Calculating distance between branches