Forum Discussion
Distance DAX
Are you looking for the distance of Every (all 50) points FROM the same Lat 43.72 and long -79.7 every time?
What was the first example Lat/Lon you used in testing to get 9.2 vs. 10.1? (Assuming I have 43.72 x -79.7 as the starting point)
FOrrest
=IF(SIN(D2) * SIN(D3) + COS(D2) * COS(D3) * COS(F2 - F3) > 1,
3963.1 * ACOS(1), 3963.1 *
ACOS(SIN(D2) * SIN(D3) + COS(D2) * COS(D3) * COS(F2-F3)))
I think, I get you wrong. So I have fifty rows of Latitude and 50 row of Longtitude.
When I use the formula you shared. I got 9.2152. My Lat is 43.72 and long is -79.7.
When I pug this lat and long into google map it is showing me 10.1 miles. Do you belive is there any problem?
Thanks
Amjad
Hi Anonymous ,
can you provide a representative dataset?
Are you looking for the distance of Every (all 50) points FROM the same Lat 43.72 and long -79.7 every time?
What was the first example Lat/Lon you used in testing to get 9.2 vs. 10.1? (Assuming I have 43.72 x -79.7 as the starting point)
FOrrest
Hi Fhill,
Sorry for late reply, I was away. So here is the detail.
I want to know all 50 lat and longtitude distance in miles from one location to see which one is best or near.
for example, 43.42-80.70 to 43.78-79.55 and so on.
Thanks
