Find the closest locations in a table

[kdrees21]

I am trying to pull in the 3 closest stores to the store in the row. 

Store	Latitude	Longitude
A	43.856024	-111.774702
B	42.014946	-87.768669
C	33.894896	-84.194279
D	31.849414	-86.647217

What I would like to accomplish is having 3 additional columns that calls out the closest stores. 

Store	Latitude	Longitude	Closest Store 1	Closest Store 2	Closest Store 3
A	43.856024	-111.774702
B	42.014946	-87.768669
C	33.894896	-84.194279
D	31.849414	-86.647217

Any Help is greatly appreciated.

[truptis · Accepted solution]

Hi @kdrees21 , 

Refer the below links:
https://community.powerbi.com/t5/DAX-Commands-and-Tips/Latitude-Longitude-amp-Top-3-Closest/m-p/1912... 

https://stackoverflow.com/questions/50757321/power-bi-find-closest-location-based-on-lat-lng 

Hit the thumbs up if it helps you. Thank you. 

[kdrees21]

Actually thank you, this was exactly what I needed and led me to the right sources.