convert Kilometres to Miles

[SharonCNE]

Hi everyone!  I have a table of locations using Long and Lat and need to show on a table the distance between two locations.  I found this and it works great in kilometres but need it in miles

1 2 3 4 5 6 7 8 9 10 11 12 13

Kilometers = var Lat1 = MIN('From City'[lat]) var Lng1 = MIN('From City'[lng]) var Lat2 = MIN('To Cities'[lat]) var Lng2 = MIN('To Cities'[lng]) ---- Algorithm here ----- var P = DIVIDE( PI(), 180 ) var A = 0.5 - COS((Lat2-Lat1) * p)/2 +     COS(Lat1 * p) * COS(lat2 * P) * (1-COS((Lng2- Lng1) * p))/2 var final = 12742 * ASIN((SQRT(A))) return final

[Greg_Deckler]

...

RETURN final * 0.62137119

Might be interested in this:

https://community.powerbi.com/t5/Quick-Measures-Gallery/Going-the-Distance/m-p/963267#M423

[SharonCNE]

Greg - that was an easy fix!  thank you 🙂  Don't suppose you know anything about calculating driving distance?

[Greg_Deckler]

Hmm, not sure I have seen that, I would think in order to do something like that you would need to call out to some kind of map API, that's a much harder problem to solve!!