cancel
Showing results for
Did you mean:
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

#### Announcing the New Spanish Forum

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

#### MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

#### ‘Better Together’ Integration Forum Launch

We've launched a how-to forum where you can learn about how Power BI integrates with other Power Platform products.

Top Solution Authors
Top Kudoed Authors