Answered

Distance in miles using Haversine formula

(0) Share

Report

Posted on by LostMary

Hi,

I am trying to calculate a distance (as the crow flies) in my canvas app, in a label, between two sets of Longitudes and Latitudes.

For example, this is my code so far for the label:

Text(
 Round(
 3959 * 2 * Atan2(
 Sqrt(
 Sin((52.45202297146137 * Pi()/180 - 50.84629323 * Pi()/180) / 2) ^ 2 + 
 Cos(50.84629323 * Pi()/180) * Cos(52.45202297146137 * Pi()/180) * 
 Sin((-1.9431014756895428 * Pi()/180 - 0.47030607 * Pi()/180) / 2) ^ 2
 ), 
 Sqrt(
 1 - (
 Sin((52.45202297146137 * Pi()/180 - 50.84629323 * Pi()/180) / 2) ^ 2 + 
 Cos(50.84629323 * Pi()/180) * Cos(52.45202297146137 * Pi()/180) * 
 Sin((-1.9431014756895428 * Pi()/180 - 0.47030607 * Pi()/180) / 2) ^ 2
 )
 )
 ), 
 2
 ) & " miles"
)

But this shows as 12285.87 miles.... when in actual fact the distance is 188 miles.... what am I doing wrong here?

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

mmbr1606 14,629 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
hey @LostMary

try this:
Text( Round( 3959 * 2 * Atan2( Sqrt( Sin((52.45202297146137 * Pi()/180 - 50.84629323 * Pi()/180) / 2) ^ 2 + Cos(50.84629323 * Pi()/180) * Cos(52.45202297146137 * Pi()/180) * Sin((-1.9431014756895428 * Pi()/180 - 0.47030607 * Pi()/180) / 2) ^ 2 ), Sqrt( 1 - ( Sin((52.45202297146137 * Pi()/180 - 50.84629323 * Pi()/180) / 2) ^ 2 + Cos(50.84629323 * Pi()/180) * Cos(52.45202297146137 * Pi()/180) * Sin((-1.9431014756895428 * Pi()/180 - 0.47030607 * Pi()/180) / 2) ^ 2 ) ) ), 2 ) & " miles" )

Let me know if my answer helped solving your issue.

If it did please accept as solution and give it a thumbs up so we can help others in the community.

Greetings

Was this reply helpful? Yes No
LostMary 42 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks @mmbr1606 but its still showing as 12285.87 miles 😞

Was this reply helpful? Yes No
mmbr1606 14,629 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
another guess:
Text( Round( 3959 * 2 * Atan2( Sqrt( Sin((52.45202297146137 * Pi()/180 - 50.84629323 * Pi()/180) / 2) ^ 2 + Cos(50.84629323 * Pi()/180) * Cos(52.45202297146137 * Pi()/180) * Sin((-1.9431014756895428 * Pi()/180 - (-0.47030607 * Pi()/180)) / 2) ^ 2 ), Sqrt( 1 - ( Sin((52.45202297146137 * Pi()/180 - 50.84629323 * Pi()/180) / 2) ^ 2 + Cos(50.84629323 * Pi()/180) * Cos(52.45202297146137 * Pi()/180) * Sin((-1.9431014756895428 * Pi()/180 - (-0.47030607 * Pi()/180)) / 2) ^ 2 ) ) ), 2 ) & " miles" )

Let me know if my answer helped solving your issue.

If it did please accept as solution and give it a thumbs up so we can help others in the community.

Greetings

Was this reply helpful? Yes No
LostMary 42 on at

Like
a
(0)

Report
Copy link

Link copied!

@mmbr1606 That says 12309 miles.......

Was this reply helpful? Yes No
Verified answer

timl 37,283 Super User 2026 Season 2 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @LostMary

The following formula should produce the correct result.

With( { r: 3958.8, p: (Pi() / 180), latA: 52.45202297146137, lonA: -1.9431014756895428, latB: 50.84629323, lonB: 0.47030607 }, (2 * r) * Asin(Sqrt(0.5 - Cos((latA - latB) * p)/2 + Cos(latB * p) * Cos(latA * p) * (1 - Cos((lonA - lonB) * p)) / 2)) )

The result of this is 151 miles.

This is the same result that you get from online calculators, and it's more or less what I see when I type those co-ordinates into Google Maps.

I have a post here that describes this formula in more detail:
http://powerappsguide.com/blog/post/formulas-calculate-the-distance-between-2-points-longitude-latitude

Was this reply helpful? Yes No