Find nearest distance from GPS coordinates

Hi everyone,

I've arrived at the solution on my own in power query, with the following steps:

I created a custom column which a trivial value and self joined the table on that value creating a row for each existing row as follows: 

I used the following formula in a custom column to calculate the distance from each set of cooridnates

Number.Acos(Number.Cos([LatRad1])*Number.Cos([LatRad2])+Number.Sin([LatRad1])*Number.Sin([LatRad2])*Number.Cos([LonRad1]-[LonRad2]))*6371​

Then made another custom column to filter out when the distance to a work site would be measured against itself:

if [Id1] = [Id2] then 1 else null

Then grouped all rows by the first 3 columns to achieve the following:

I created another custom column to claulcate the minium distnace in the grouped rows

Table.Min([AllRowsGroup], "DistanceToTank")

 Finally i expanded the column to achieve the final result.

Thank you to everyone who gave their recomendations. Just an FYI to those that might attempt this themselves, that i had to convert the GPS cooridnates to radians before i was able to use this formula. If i hadn't done this first you could easilly augment the distance formula above to convert those in-line.

Thanks again everyone!