cancel
Showing results for
Did you mean:
Highlighted
Helper I

Calculating distance from a source location to multiple destinations using long and lat

1 ACCEPTED SOLUTION

Accepted Solutions
Super User IV

Re: Calculating distance from a source location to multiple destinations using long and lat

@Antonio195754 here is the solution, you can make the changes as per your need. I guess you have starting point, but feel free to reach out if need further help.

Proud to be a Datanaut! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

20 REPLIES 20
Super User IV

Re: Calculating distance from a source location to multiple destinations using long and lat

@Antonio195754 I assume you have relationship between these table, 1 to many (1 side is Airport table and many side is cell phone towers tables), can you please confirmt this? Also if you can post some example airport and cell towers in excel sheet, it will help to get you the solution.

Proud to be a Datanaut! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Super User III

Re: Calculating distance from a source location to multiple destinations using long and lat

as @parry2k already mentioned it would be helpful to get sample data and if a 1 to many relationship can be established.

This link might be helpful, as you will see there are some things to consider to calculate the distance between two points if want or have to consider that this thing we live on, behaves like a globe 🙂

https://www.movable-type.co.uk/scripts/latlong.html

Regards,

Tom

Hamburg - Germany
I accept Kudos :-), If you find my post helpful.

Proud to be a Datanaut!
Super User IV

Re: Calculating distance from a source location to multiple destinations using long and lat

Thanks @TomMartens

@Antonio195754 read this post from @Greg_Deckler regarding how to get answer quickly.

Proud to be a Datanaut! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Helper I

will do

Super User IV

Re: Calculating distance from a source location to multiple destinations using long and lat

@Antonio195754 two things:

- screen shot is good but for teting the solution, it is good to get data in excel so that we can import on our end in powerbi.

Proud to be a Datanaut! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Helper I

Super User IV

Re: Calculating distance from a source location to multiple destinations using long and lat

@Antonio195754 No worries. Unfortunately you cannot uploade it here, you can share thru one drive or google drive and share the link here.

Proud to be a Datanaut! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Helper I

Super User IV

Re: Calculating distance from a source location to multiple destinations using long and lat

@Antonio195754 seems like it is not shared publically, it is asking me to login.

Proud to be a Datanaut! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Announcements

‘Better Together’ T-Shirt Contest – Winner Announced!

And the winner is...

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

April 2020 Community Highlights

Info on our Super Users, MBAS content and badges, and updates to our support articles. - Read the full Community Highlights.

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

Top Solution Authors
Top Kudoed Authors