Forum Discussion

HenryJS's avatar
HenryJS
Post Prodigy
6 years ago

Calculate Radius Distance With Dax

Hi all,   I have two tables (below) and would like to create a 25km distance around the 'Company Name' and find which of the 'CandidateRef' in the table beneath are within this.   Can anyone advi...
Data Protection
Need Help
Show and Tell
Tips and Tricks
v-juanli-msft's avatar
v-juanli-msft
Community Support
6 years ago

Hi HenryJS 

If it is difficult to implement, please feel free to let me know.

According to your previous post, it seems you want to get distances of every 'CandidateRef' away from every 'Company Name' ,

then filter out the Candidates for every 'Company Name' which distances are less than or equal to 25km distance.

In this case, i would suggest you to exact data from two tables about location name,

(add a column to define the type "Company' or 'Candidate')

and latitude/longitude, then append two tables.

 

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