How to Calculate Distance on map from one Postcode to Another Postcode

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

Thanks Greg_Deckler 

I have had a quick look but I cannot quite figure out how its working, or how I could get it to work for my use.

If I have a list of postcodes with long and lat for each in a table, how would I use this to produce a table of the closest other postcodes? Ideally I would love to have the actaul distance in miles listed as well.

Any chance you could point me in the right direction please?

ToughTake Sure, can you post a sample of the data you have? Then I can mock things up.

Thanks so much!

Sample wise, please see the below dummy data.

https://file.io/ZCj3MVXwfIZG

Again thanks so much!

Morning Greg_Deckler 

Was the sample data enough to work with, did you need anything else from me?

Thank you again for you help.

Hi Greg_Deckler 

Just checking if you have had chance to look into this yet?

Happy to provide any more information that you might need?

Hi Greg!

Hope you are well and dont mind me jumping on this thread.

I have a excel document with postcodes in (uk) and i would like to work out the miles between 2.

I have the latitude and longitude and can get the distance between the points but i assume that is as a 'crow flys' not by road? Can you see if i have gone wrong on a formula?

Thank you!

Kris