Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
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!
Solved! Go to 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/
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/
User | Count |
---|---|
12 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
25 | |
19 | |
14 | |
10 | |
7 |