Forum Discussion

Helper I

5 years ago

Solved

Using 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 s...

Need Help

Anonymous
5 years ago
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/73988

Best Regards,

Jay

Anonymous

Not applicable

5 years ago

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
Helper I
5 years ago
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
  Not applicable
  5 years ago
  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/73988
  
  Best Regards,
  
  Jay

Forum Discussion

Using Long Lat add city names

Related content

Create long Month Name

RLS using aduser name

Refresh time too long

Lakehouse File name

Using List.Contains causing long load time