How to create a column that determines the county from column that has zip codes?

[Anonymous]

I have a column that says the zip code for each row of order data. I need to create an additional column that says which county each zip code is in. 

[v-xiaosun-msft · Accepted solution]

Hi @Anonymous ,

If you want to show the country of each zip code on visual, you can select "map", and then put "zip code" into "location". You can also turn on the "Category labels" to show the zip code on the visual.

If you want to show the country of each zip code in the table, you need to have the data about zip code and country name so that you can reference it.

And I suggest you can try MahyarTF's @MahyarTF  suggestion to download the data to add a new table which includes the zip code and country name. Then establish a relationship between two tables with "zip code".

Finally, you can reference the "country" on your original table.

Best Regards,
Community Support Team _ xiaosun

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

[MahyarTF]

Hi,

In my point of view, you need to have another table that is included the zip code and country name and then make a relation between this and your table and use the countries' names in your visual. There is plenty of site you could download the data like :

https://www.postcodezip.com/

https://data.opendatasoft.com/explore/dataset/geonames-postal-code@public/export/

Appreciate your Kudos and please mark it as a solution if it helps you.