Forum Discussion
State Numbers Converted to State Names
Hi i820017
From this point, you need to create a relationship between the tables that you ate at.
In order to assist in a more informed manner
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
Based on the file, I couldn't figure out what you were trying to accomplish.
Are all possible combinations included in the data you are analyzing?
When a user chooses a country, are they choosing a number or a word?
Why does he choose combinations over countries, rather than a country followed by a combination?
Here are the answers to your questions
Are all possible combinations included in the data you are analyzing?
No, all possible combinations are not included in the data that I am analyzing. I would use a SWITCH function if that were the case
When a user chooses a country, are they choosing a number or a word?
When a user chooses a state (not a country...I apologize for being unclear on that), then he is choosing a number. 1 = Alabama, 2 = Alaska, 3 = Arizona, etc
Why does he choose combinations over countries, rather than a country followed by a combination?
He is choosing states, not countries...He is assigning policies to certain states. For example, policy A might be assigned to 1 state or more than 1 state. Policy B might be assigned to 1 state or more than 1 state, etc