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, ...
Anonymous suggest you split column on delimiter (,). You can do this in Power Query by right-clicking the column header and choosing that option.
So my data is coming from Dynamics 365 and it is not seperated by , but i did find that i can do a replace item for each.
Could there be another option HotChilli ?