Forum Discussion
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...
MFelix
Super User
Super UserHi 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
Calculation distance between latitudes & Longitudes | Microsoft Fabric Community
I have already added or used the calculation into shared file, just want highlight the selected location in red color