Forum Discussion
Solved
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 ...
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.
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.