Calculate distance in Power Pivot (Power BI Desktop)

[dhExcel]

By using the new trigonometric DAX functions available in Power BI desktop, straight-line distance on the Earth can be calculated. The new DAX variable feature also comes in handy in constructing this useful formula.

See: https://dhexcel1.wordpress.com/2015/08/16/measuring-distance-in-power-bi-desktop/

Hope that you find this useful!

 

[cyrilbrd]

Is this giving you a distance in Miles?
You could also use for the distance in Km:
New measure [RadiusEarth] = 6371
And New Column
Distance_km = [RadiusEarth]*((2*ASIN(SQRT((SIN((RADIANS(Distance[Lat_1])-RADIANS(Distance[Lat_2]))/2)^2)+COS(RADIANS(Distance[Lat_1]))*COS(RADIANS(Distance[Lat_2]))*(SIN((RADIANS(Distance[Long_1])-RADIANS(Distance[Long_2]))/2)^2)))))