Forum Discussion
Show distance between two points
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 | LinkedInIf this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.
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!
- 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.
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.
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...
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!
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!
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.
- 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.