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...
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...
Hi Greg_Deckler This is brilliant!
Sorry for replying 3+ years later, but have just stumbled across this.
Would it be possible to tweak this so rather than having to add in a to and from for every location in a tbale you could select a postcode (slicer) and it give you a list of the top X closest postcodes to your selection?
Any help on this would be greatly appreciated!
ToughTake Possibly. I did something along those lines once: Near - Microsoft Fabric Community
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.