Forum Discussion
Helper IVCalculating 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.
20 Replies
- parry2k
Super User
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.
- TomMartens
Hey Antonio195754
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
- parry2k
Thanks TomMartens
Antonio195754 read this post from Greg_Deckler regarding how to get answer quickly.
Antonio195754will do
- parry2k
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.
- in your model, your airport code is unique?
