Forum Discussion
Advocate IPBI Maps based on Geo Coordinates
I would do something like this:
A user selects its location which is point A and the distance is calculated from point A to several Point B's. The user selects the maximum radius. The shortest is what you'll likelly recommend to the user but you can show other locations as an option.
https://community.fabric.microsoft.com/t5/Data-Stories-Gallery/Philippine-Barangays-on-the-Map/m-p/3384116Here's the tutorial https://www.youtube.com/watch?v=5nkPRsD-olM
Super UserHi prasadhebbar315
The only thing I can think of is to use the Haversine formula to calculate the shortest distance between two points but this doesn't take into account that going from points A to B isn't always a straight line. You can ask ChatGPT to give you the formula in DAX. If you want the actual distance, you'll need to use the Distance Matrix API from Google or similar ones - https://developers.google.com/maps/documentation/distance-matrix/overview