Forum Discussion
Mixed Data for States Column
Hey Power BI Team! I have mixed date for a state column that has both the state abbreviations and the state name. Is there a way to make it so they are all the state Abbreviations? EX: TX, ...
Are all the fields in abbreviation, StateName format and you want to return only the abbreviation i.e. the portion to the left of the comma?