Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
6 years ago

Going the Distance

Uses the Haversine formula to compute the distance between the latitudes and longitudes of two points.     c = VAR __FromCity = SELECTEDVALUE('From City'[City]) VAR __ToCity = SELECTE...
Mathematical
Other
MYDATASTORY's avatar
MYDATASTORY
Icon for Resolver I rankResolver I
6 years ago

Greg_Deckler  This is great, looking forward to seeing the final distance calculation.

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    6 years ago

    MYDATASTORY 

     

    OK, I downloaded the UK Postal Code latitudes and longitudes from here:

    https://www.freemaptools.com/download-uk-postcode-lat-lng.htm

     

    You guys sure have a lot of postal codes, apparently about 1.7M of them and since they are unique as well as the latitudes and longitudes, well, it makes for a fairly sizeable file. Anyway, I went ahead and implemented a few columns and such to get the distances.

     

    However, they only allow a maximum upload file size of 50MB and the file is nearly twice that. So I am uploading to my personal OneDrive and will share out a file from there. Hang tight.