topic Re: Help: Geo Location within Geo Area in DAX Commands and Tips

Help: Geo Location within Geo Area

RT3308 — Sat, 05 Jul 2025 14:31:10 GMT

Please help...

I've got two tables. One table has the locations of certain buildings (lon and lat). Second table has geo areas (list of lon and lat). How do I determine which geo area the record in table 1 is within (or closest to)?

Appreciate the help. Thanks.

Re: Help: Geo Location within Geo Area

lbendlin — Sat, 05 Jul 2025 15:14:47 GMT

That is an extremely complex topic, far beyond the capabilities of Power BI.

Geofencing – Determining Whether a Point Is Inside of a Polygon | Baeldung on Computer Science

Re: Help: Geo Location within Geo Area

tharunkumarRTK — Sun, 06 Jul 2025 10:37:12 GMT

RT3308

In my opinion, you can convert your table into a GeoJson and feed it as insput to azure maps or icon map visual.

https://learn.microsoft.com/en-us/azure/azure-maps/how-to-dataset-geojson

then you can plot your buildings (lat and long) on top of the area highlighted by the Geo Json.

I understand that it wont give the exact distnace between the building and the locations in table 2. However the representation on the map will give good visual representation. If you want to calculate the distatance between two geo locations you. have to use Haversine formula

https://stackoverflow.com/questions/18883601/function-to-calculate-distance-between-two-coordinates#:~:text=What%20you're%20using%20is%20called%20the%20haversine,doing%20geographic%20calculations%2C%20and%20also%20shows%20a

Connect on LinkedIn

Did I answer your question? Mark my post as a solution!
If I helped you, click on the Thumbs Up to give Kudos. Proud to be a Super User!

Re: Help: Geo Location within Geo Area

Anonymous — Tue, 08 Jul 2025 04:28:03 GMT

Hi RT3308 ,
Thank you for the helpful responses tharunkumarRTK and lbendlin !
The provided answer is accurate and may help you to resolve the query.Have you got an opportunity to review the information provided by community members?If it resolved, consider accepting their answer as solution.
Thank you.

Regards,
Pallavi.