Forum Discussion
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])+...
You can get the results in miles and then do a convertion multiplying the result by 1.6
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...
Any help on this use case...