Forum Discussion
Distance DAX
Hi Everyone, I am trying to make graph on power BI by using Longtitude and Latitude information. I want to know how can I use DAX funtion in power BI to get the distance in miles from one point t...
Are you looking for the distance of Every (all 50) points FROM the same Lat 43.72 and long -79.7 every time?
What was the first example Lat/Lon you used in testing to get 9.2 vs. 10.1? (Assuming I have 43.72 x -79.7 as the starting point)
FOrrest
I had to do this recently between zip codes in Excel. You have to convert Lat & Lon cordinates into Radiant values first, then you can use the formula in the 2nd screen shot. DAX has a RADIANS, SIN & COS calcuation just like Excel.
The hard part may be how to display this information? You'll need 2 sets of Lat & Lon to perform the calcuation, and I don't know how you plan to 'match up' two points to do so?