Forum Discussion
Distance Calculation from Latitude & Longitude Data
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.
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.Hello edhans,
Thank you for the solution. This is definitely worked.
2 Replies
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.Hello edhans,
Thank you for the solution. This is definitely worked.