Forum Discussion

Swami_om's avatar
Swami_om
Frequent Visitor
1 day ago

Distance-Based Location Highlighting

 Hello, I’m trying to calculate the distance between the assigned location and the employee’s home location using the latitude and longitude available in this file. The objective is to identify loc...
Help me
Power BI Dax
Power BI Geo
Show & Tell
MFelix's avatar
MFelix
Icon for Super User rankSuper User
1 day ago

Hi Swami_om​ ,

For this you need to use a specific formula that is used to calculate the distance between two points on earth.

Check this post below with the calculation and also an example:

https://dax.tips/2017/05/13/dynamic-distances-in-power-bi/ (This is from a master in DAX Phil Seamark) Includes a copy of the PBIX.

Distance Calculation from Latitude & Longitude Data | Microsoft Fabric Community

https://medium.com/@trancyle/calculate-the-distance-between-locations-with-longitude-latitude-in-power-bi-d35a18056760

Calculation distance between latitudes & Longitudes | Microsoft Fabric Community

 

  • Swami_om's avatar
    Swami_om
    Frequent Visitor
    1 day ago

    I have already added or used the calculation into shared file, just want highlight the selected location in red color