Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Distance DAX

Hi Everyone,   I am trying to make graph on power BI by using Longtitude and Latitude information. I want to know how can I use DAX funtion in power BI to get the distance in miles from one point t...
Need Help
  • fhill's avatar
    fhill
    5 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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

fhill's avatar
fhill
Resident Rockstar
5 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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