![]() If you prefer km, then change the ending constant to 6371. Lon1 = (lon1Decimal / 180) * PI (3.14159265359) – repeat for 2įinally, use this formula in Excel to derive the distance in Miles. The first step is expressing each Latitude/Longitude of both of the coordinates in radians: It has all the needed trig functions to calculate the distance in miles between two points using Longitude and Latitude where they are expressed in decimal form. Barbara Raney Microsoft Excel, Microsoft Excel 2013, Power BI Desktop, Power Pivot, Power Query (M) Comments Off on Use Power Query to Calculate Distanceĭistance calculations! Over the past couple of years, I have had several clients who are using PowerPivot who want to measure the distance between two points on a map: Client to distribution center or building to building.įor just a few calculations, this is very straight-forward using plain old Excel.
0 Comments
Leave a Reply. |