Distance Calculation from Latitude & Longitude Data

[SURYA3696]

Hello All,

I am trying to generate distance in KM from the Latitude & Longitude data that I have. The dataset contains more than 3000 lines and the frequency of data output is at a time interval of every 5 seconds. I initially tried to produce distance by dividing the speed (km/hr) by 5 seconds in Hours. But the distance I calculated did not look realistic (incorrect). 

Can someone help with this please. 

[edhans · Accepted solution]

You need to use the haversine formula. There is no built in function for this in DAX or M, but the underlying functions are there, like SIN() in DAX or Number.Sin in M.

Seems pretty straightforward, just a bit tedious to build.

https://www.omnicalculator.com/other/latitude-longitude-distance#the-haversine-formula-or-haversine-...

[edhans · Accepted solution]

You need to use the haversine formula. There is no built in function for this in DAX or M, but the underlying functions are there, like SIN() in DAX or Number.Sin in M.

Seems pretty straightforward, just a bit tedious to build.

https://www.omnicalculator.com/other/latitude-longitude-distance#the-haversine-formula-or-haversine-...

[SURYA3696 · Accepted solution]

Hello edhans, 

Thank you for the solution. This is definitely worked.