Forum Discussion
Helper IUsing Long Lat add city names
Hi, I want to add city names on my data with long Lat. is it anyhow possible in powerbi?
I have a table where I have different locations (xy)-shops in Germany and I want to know in which city this shops are located.
I downloaded German cities with coordinates, but could not make it work.
my locations:
| Long | Lat | Close city Name |
| 8.46215 | 50.2334 | Empty. |
Any help would be appreciatable.
Br,G
Hi leopoldvili_1 ,
You could refer these topics about how to find the nearest location based on the given coordinates.
https://community.powerbi.com/t5/Desktop/Find-the-nearest-location-for-a-customer/m-p/217048
Best Regards,
Jay
5 Replies
- amitchandak
Super User
leopoldvili_1 , Not very clear. If you have city name in one table and City name long, lat in another table, you can merge them in power query
leopoldvili_1Hi amitchandak thank you for your reply. No i dont have a city name in another table only xy.
Br, G
Hi leopoldvili_1 ,
I don't think Power BI has such feature. But if you have a table that contains Long Lat and city name, we might be able to do this with DAX.
Best Regards,
Jay
- leopoldvili_1
Hi Anonymous i have city coordinates as city centers only. Downloaded from this link https://www.basedig.com/german-government/list-of-all-cities-and-towns-in-germany-with-gps-coordinates-4937/.
and I have another table with locations spreaded in the different city, only have Long, Lat
Hi leopoldvili_1 ,
You could refer these topics about how to find the nearest location based on the given coordinates.
https://community.powerbi.com/t5/Desktop/Find-the-nearest-location-for-a-customer/m-p/217048
Best Regards,
Jay
