Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 advise how to do this?
1. Company Table
3. Candidate Table
Thanks,
Henry
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.
Hi @v-juanli-msft ,
Yes - my understanding is that I need to calculate the distance of every company from every candidate in the 'CandPost' table.
However when I created a new column and input the below DAX in I got the same value for every candidate? Please see below column 'Distance from Compound'.
Do I need a column for every company?
Hi @HenryJS
Please refer to :
Display Points within a Distance Radius on a Power BI Map
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
95 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |