Forum Discussion
Display Stores Within Radius for Multiple ZIP Codes
Hi everyone, I am working on a Power BI report using Azure Maps. I have a STORE table that contains: Store name Address Latitude Longitude I also have a ZIPCODE table that contains all vali...
It's technically trivial (using the Haversine formula) but it has limited value. The center of a ZIP code may not have any business meaning, and the Great Circle distance may not have a business meaning either. What you would need is a real time driving distance/time route engine connection - and that becomes expensive quickly.
What problem are you trying to solve with that visual?
- I’ve already used the Haversine formula to calculate the distance between a single coordinate and a set of stores and I can successfully display all stores within a given radius r. However, I’m struggling to extend this logic to handle multiple user‑entered ZIP codes.My goal is to identify all potential stores located within a radius r of each user‑provided ZIP code.How can I efficiently compute this for multiple ZIP code inputs?
