Forum Discussion
Map and midpoint help
all,
wanting to find the midpoint between either two pins or the query of addresses. can this be done?
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 QueryAppreciate your Kudos
Connect with me!
1 Reply
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 QueryAppreciate your Kudos
Connect with me!