Using Long Lat add city names

[leopoldvili_1]

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

[Anonymous]

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

[Anonymous · Accepted solution]

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 

https://community.powerbi.com/t5/Desktop/Calculate-nearest-points-by-geographical-coordinates/m-p/73... 

Best Regards,

Jay

[amitchandak]

@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_1]

Hi @amitchandak thank you for your reply. No i dont have a city name in another table only xy. 

Br, G