Forum Discussion
Distance between 2 locations
Hi, I have Location Code, Location Name, Longitude, Latitude, Revenue data in an excel. I have plotted those locations on the bubble map in Power BI. I want that when a user selects 2 locations f...
HI Laraib_Ghafoor,
In the sample data you PM'd to me, some regions have more than one Lat/Lng. Which is your preferred Lat/Long to use for a Region A when there is more than one?
Hi Phil, can you please assist me with a variation on that distance inbetween solution above. I am tryring to find the distance in meters and between to sets of lat/lng co-ordinates.
I have the excel formula as
=SQRT(([@[Place_latitude]]-[@[Latitide]])^2 + ([@[Place_longitude]]-[@[Longitude]])^2)
Can you please help me to create this formula in power query as i have to much data to do it through excel and serverly stuck