Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
I am trying to map the distance between the locations of prospects and dealers/outlets.
For prospects, I have columns relating to partial address, postcode and state in a dataset. No gps though.
How do I generate their location in Power bi using these data?
Solved! Go to Solution.
Hi, @flintstone
You can use google maps , enter the postcode to get the latitude and longitude of the member's approximate location. Another method: Google Maps API V3: Get Location (Latitude and Longitude) from Zip Code (Pin Code) using JavaScript ...
Although this may be a bit cumbersome, it may not be recognized without a specific location.
Best Regards
Janey Guo
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @flintstone
You can use google maps , enter the postcode to get the latitude and longitude of the member's approximate location. Another method: Google Maps API V3: Get Location (Latitude and Longitude) from Zip Code (Pin Code) using JavaScript ...
Although this may be a bit cumbersome, it may not be recognized without a specific location.
Best Regards
Janey Guo
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@flintstone , do you have long, lat information? because using that you can easily get the distance.
Sorry, I had mentioned before. No gps data => no long nor lat
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
113 | |
104 | |
98 | |
39 | |
30 |