Forum Discussion
Assigning Counties by Zip Code
I need to assign a county based on the zip code in my data file. Does Power BI have anything that would assign a county based on zip code?
Trying to get suggestions on the best way to do this in Power BI. I can group by states, but for the state of WA, I need to break down by two counties and then the rest of the state of WA.
Thank you!
Alaska1 Based on your description, my uderstanding is that you need some table of counties and thier zip codes, if yes, you need to import this details from internet. I randomly googled it and found. You could search it too. Then import that table and link it with your own data table on zip code.
2 Replies
Alaska1 Nothing native. Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882
Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.Alaska1 Based on your description, my uderstanding is that you need some table of counties and thier zip codes, if yes, you need to import this details from internet. I randomly googled it and found. You could search it too. Then import that table and link it with your own data table on zip code.
