Show distance between two points

[Henrique_Quint]

Hey everyone,

I'm trying to show distance between two points on an ArcGIS map, but here's the thing, I have a table of deliveries and 4 different columns for coordinates (Latitude starting point, Longitude starting point, Latitude ending point, Longitude ending point). Is there a way to do it?

[pankajnamekar25 · Accepted solution]

Hello @Henrique_Quint  

Yes that is possible use below DAX code

Distance (km) =

VAR Lat1 = RADIANS([Latitude Start])

VAR Lon1 = RADIANS([Longitude Start])

VAR Lat2 = RADIANS([Latitude End])

VAR Lon2 = RADIANS([Longitude End])

VAR DLat = Lat2 - Lat1

VAR DLon = Lon2 - Lon1

VAR A =

    POWER(SIN(DLat / 2), 2) +

    COS(Lat1) * COS(Lat2) * POWER(SIN(DLon / 2), 2)

VAR C = 2 * ATAN2(SQRT(A), SQRT(1 - A))

VAR EarthRadius = 6371 -- Kilometers

RETURN

 EarthRadius * C

Thanks,
 Pankaj Namekar | LinkedIn

If this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.

[pankajnamekar25 · Accepted solution]

Hello @Henrique_Quint  

Yes that is possible use below DAX code

Distance (km) =

VAR Lat1 = RADIANS([Latitude Start])

VAR Lon1 = RADIANS([Longitude Start])

VAR Lat2 = RADIANS([Latitude End])

VAR Lon2 = RADIANS([Longitude End])

VAR DLat = Lat2 - Lat1

VAR DLon = Lon2 - Lon1

VAR A =

    POWER(SIN(DLat / 2), 2) +

    COS(Lat1) * COS(Lat2) * POWER(SIN(DLon / 2), 2)

VAR C = 2 * ATAN2(SQRT(A), SQRT(1 - A))

VAR EarthRadius = 6371 -- Kilometers

RETURN

 EarthRadius * C

Thanks,
 Pankaj Namekar | LinkedIn

If this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.

[Henrique_Quint]

Hi, @pankajnamekar25 ! I've already done this measure, What I want to do is show the Start AND End on the map while also having 4 columns of coordinates...

[v-aatheeque · Accepted solution]

Hi @Henrique_Quint ,

Reshape the data in Power Query to create two rows per deliver

• one for the start point and one for the end point, with unified Latitude, Longitude, and a Point Type column then plot them in ArcGIS using Point Type as legend.
  
  

If this post was helpful, please consider marking Accept as solution to assist other members in finding it more easily.

If you continue to face issues, feel free to reach out to us for further assistance!

[v-aatheeque]

Hi @Henrique_Quint ,

We haven’t heard back from you regarding our previous response and wanted to check if your issue has been resolved.

If it has, please consider clicking “Accept Answer” and “Yes” if you found the response helpful.
If you still have any questions or need further assistance, feel free to let us know — we're happy to help!

Thank you!

[v-aatheeque]

Hi @Henrique_Quint 

If the information is helpful, please accept the answer by clicking the "Upvote" and "Accept Answer" on the post. If you are still facing any issue, please let us know in the comments. We are glad to help you.

We value your feedback, and it will help us to assist others who might have a similar query. Thank you for your contribution in enhancing Microsoft Fabric Community Forum.

[v-aatheeque]

Hi @Henrique_Quint ,

We haven’t heard back from you regarding our previous response and wanted to check if your issue has been resolved.

If it has, please consider clicking “Accept Answer” and “Yes” if you found the response helpful.
If you still have any questions or need further assistance, feel free to let us know — we're happy to help!

Thank you!