Forum Discussion
Clean column from delimiter
I have a column with City, number, Country. Some of the rows only have number, Country and some have Country. I would like to clean it so it is only showing the Countries. See picture: ...
AlB
Yes, it is working with that column. But I want it ti refer to the column SYSTEM_LOCATION.
I took the code you shared with me and it made it like that.
Anonymous
Like I said, the code is probably referring to the wrong column and should be easy to fix, but I need to see your M code to be able to see where the issue is. Or if you can share your pbix file, even better.
Please mark the question solved when done and consider giving kudos if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Cheers