Forum Discussion

Henrique_Quint's avatar
Henrique_Quint
Helper I
1 year ago
Solved

Show distance between two points

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?

Need Help
  • pankajnamekar25's avatar
    pankajnamekar25
    1 year ago

    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.

  • v-aatheeque's avatar
    v-aatheeque
    1 year ago

    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!

6 Replies

  • pankajnamekar25's avatar
    pankajnamekar25
    Super User
    1 year ago

    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's avatar
      Henrique_Quint
      Helper I
      1 year ago

      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's avatar
        v-aatheeque
        Community Support
        1 year ago

        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!