Column: Calculate Distance Using Log/Lat

[HenryJS]

Hi all,

I have two tables (below). I want to create a new column in 'CandPost' table which calculates distance of each 'CandidateRef' from the 'Small Dean' long/lat in table 1 below.

1. 'Small Dean' table

2. 'CandPost' table

Thanks,

Henry

[v-easonf-msft · Accepted solution]

Hi , @HenryJS 

You also can refer to this article:

https://radacad.com/dynamic-distances-in-power-bi 

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

Refer, if this can help

https://community.powerbi.com/t5/Desktop/Distance-Calculation-in-Power-BI/td-p/206979

https://stackoverflow.com/questions/27928/calculate-distance-between-two-latitude-longitude-points-h...

https://forum.enterprisedna.co/t/how-do-you-calculate-km-s-travelled-using-just-lat-long-in-power-bi...

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution.
In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blogs -Decoding Direct Query - Time Intelligence, Winner Coloring on MAP, HR Analytics, Power BI Working with Non-Standard TimeAnd Comparing Data Across Date Ranges
Connect on Linkedin