Forum Discussion

Balkrishnan's avatar
Balkrishnan
Icon for Helper II rankHelper II
7 years ago

Distance between two Cities

I am getting Errow when calculating distance between two cities.  I used this formula PI_D180 = PI()/180 Distance = ACOS(SIN(Distance[Latitude_1]*[PI_D180])*SIN(Distance[Latitude_2]*[PI_D180])+...
Need Help
Balkrishnan's avatar
Balkrishnan
Icon for Helper II rankHelper II
7 years ago

Thanks for your attention on this, but i need in Miles and need to  know how to use your formula in my calculation.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

You can get the results in miles and then do a convertion multiplying the result by 1.6

  • Balkrishnan's avatar
    Balkrishnan
    Icon for Helper II rankHelper II
    7 years ago

    Let me explain my use case.

    This is my data

    I need two filters as shown below

    From City and Two City, When i select Dewitt and Bentonville, i need to know the distance between them.

    I have two formula

    PI_D180 = DIVIDE ( PI (), 180 )
    and 
    Distance = ACOS(SIN(Distance[Latitude_1]*[PI_D180])*SIN(Distance[Latitude_2]*[PI_D180])+COS(Distance[Latitude_1]*[PI_D180])*COS(Distance[Latitude_2]*[PI_D180])*COS((Distance[Longitude_2]*[PI_D180])-(Distance[Longitude_1]*[PI_D180])))*3959
     
    But getting error...
    • Balkrishnan's avatar
      Balkrishnan
      Icon for Helper II rankHelper II
      7 years ago

      Any help on this use case...