[FONT="]Can anyone recommend a DAX/function to clean up the state names of a table? In the state field, some are "VA" while others are "VIRGINIA". For the purpose of clean and easy joining in the data model, I would like to standardize the field so that every state in the field is "VA" (for all 50 states). I assume this would go in a calculated column. Any ideas? Thanks.[/FONT]