Map and midpoint help

[rackerman1]

all,

 wanting to find the midpoint between either two pins or the query of addresses.  can this be done?

[SteveCampbell · Accepted solution]

Do you have the long / lat ? You could use:

Mid = 

DIVIDE(
   DIVIDE ( LAT1 + LAT2 , 2) 
   , 
   DIVIDE ( LON1 + LON2 , 2) 
)

Otherwise, no, not without custom code / R / PY.

If you have addresses only, you could get the long lat with a geocoder, such as Bing or Google, but this often has cost and requires some Power Query

Appreciate your Kudos
Connect with me!

Stay up to date on  
Read my blogs on