I have longtitude and latitude, I need country name

[MykytYla]

I have the longtitude and latitude in the table, I need the country for this coordinate. What can I use DAX or power query

details.latitude	details.longitude	country
50.0229962	19.8952209	Poland
2.9226565	101.6514018
50.0654544	19.9446763
33.8763057	35.5204761
40.9679869	29.0818521
50.109172	19.8307899

[v-linhuizh-msft]

Thanks for the reply from @suparnababu8 .

Hi @MykytYla ,

As suparnababu8 said, DAX does not currently support this feature. Please allow me to provide another insight. We can create a custom function in Power Query and call the Google Geocoding API to find the location information.

For specific operations, please refer to the video below:

How to use the Google Geocoding API in Power BI | Quickly find Longitude and Latitude Coordinates - ...
Here is also a link to a similar problem as yours

Solved: Get city, longitude/latitude, country, or state/pr... - Microsoft Fabric Community

Best Regards,
Zhu
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.

[suparnababu8]

Hi @MykytYla 

Using DAX alone to retrieve country names from latitude and longitude coordinates is not  feasible because DAX doesn’t have built-in geocoding capabilities. May be in future we may expect from Microsoft.

DAX is primarily designed for data analysis and calculations within the data model.

I hope you are clear now!!