Forum Discussion
How to Calculate Distance on map from one Postcode to Another Postcode
Greg_Deckler Wow this is fantastic, let me have a good look at it tomorrow so I can accept the solution , I'll let you know, but definitely amazing...
Greg_Deckler Thanks for the update, any chance you can have at the look at the PBix file updated with (hyperlink) as see how will be the best way to add the calculation based on the data. Much appreciated in advance.
MYDATASTORY - Oh, I will have to take a look at the PBIX. Here I was busy creating a couple of Quick Measures for you that I just published out to the Quick Measure gallery. Here they are:
ATAN2 - https://community.powerbi.com/t5/Quick-Measures-Gallery/ATAN2/td-p/963263
Going the Distance - https://community.powerbi.com/t5/Quick-Measures-Gallery/Going-the-Distance/m-p/963267#M423
I'll take a look at your PBIX.
Greg_Deckler Wow this is great and appreciated, have a look at the file.
OK, MYDATASTORY it is finally done uploading. You can grab the file from here:
https://1drv.ms/u/s!ApodhCa32_44o9c1vhYu46mQj5xM8Q?e=KODN0B
One note, I did have to clean up some of your data because there were some errant spaces. Just FYI.
Greg_Deckler Wow this is fantastic, let me have a good look at it tomorrow so I can accept the solution , I'll let you know, but definitely amazing...
MYDATASTORY - Sorry, posted to the wrong thread
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.