Forum Discussion
Splitting Counties and States and State Code Conversion
Anonymous not sure wht you mean by decode state abbreviation. here is calculated columns looks like
Country = IF( LEN(Table[Country/State]) > 2, Table[Country/State], "USA" ) State = IF( LEN(Table[Country/State]) > 2, "", Table[Country/State])
Super UserAnonymous not sure wht you mean by decode state abbreviation. here is calculated columns looks like
Country = IF( LEN(Table[Country/State]) > 2, Table[Country/State], "USA" ) State = IF( LEN(Table[Country/State]) > 2, "", Table[Country/State])
Thank you! By decoding I mean converting CA to California, NY to New York, etc. May be I should split the column first and then decode the State?
- parry2k
Anonymous sure I already did the split for you and from there you can decode to long state name.
Is there a function to do that conversion or how is it done?
- parry2k
Anonymous you can add another table in your model with 2 digit state code and full name and then set relatonship with that table to get the full name. Populating that table must be super easy or you can connect to wikipedia using power query to get list of states and abbreviations.
Perfect! Thank you very much!