Forum Discussion
Calculate distance between Zip Codes?
I have a table with two fields as zip codes. An origination zip code and a destination zip code. I would like to calculate the milage between the two zip codes. How would I do this?
Hi Anonymous ,
The Latitude and Longitude are needed to calculate the distance between two locations with following formula:
=acos(sin(lat1)*sin(lat2)+cos(lat1)*cos(lat2)*cos(lon2-lon1))*6371 (Ps: 6371 is Earth radius in km.)
You may also achieve it via either Power Query or DAX method. Or you can use Google Map API .
Best Regards,
Amy
Community Support Team _ Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 Replies
- Greg_Deckler
Community Champion
- mahoneypat
Microsoft Employee
I would do this in the Query Editor. With a table that has the two zipcode columns, you can add a custom column that makes a web call to a REST API that does this. Here is an example one - http://www.zipcodeapi.com/API#distance
You can get a free key, and then concatenate the values from your two columns into the needed URL.
If this works for you, please mark it as solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
v-xicaiCommunity Support
Hi Anonymous ,
The Latitude and Longitude are needed to calculate the distance between two locations with following formula:
=acos(sin(lat1)*sin(lat2)+cos(lat1)*cos(lat2)*cos(lon2-lon1))*6371 (Ps: 6371 is Earth radius in km.)
You may also achieve it via either Power Query or DAX method. Or you can use Google Map API .
Best Regards,
Amy
Community Support Team _ Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
