The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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 |
---|---|
27 | |
12 | |
8 | |
8 | |
5 |
User | Count |
---|---|
31 | |
15 | |
12 | |
7 | |
6 |