Forum Discussion
Remove Spacing from Text String
Hi, I am wanting to remove spacing from the text string like "ex08 kiu" so it would read "ex08kiu" how can I acheive trhis in dax? I thought about using = Substitute(" ",textstring,"") but t...
Hi, have you maybe changed the order? I use as a calculated column:
Column without spaces = SUBSTITUTE(Table1[Header];" ";"")
and that seems to work.
/Johan
Johanno
Continued Contributor
Continued ContributorHi, have you maybe changed the order? I use as a calculated column:
Column without spaces = SUBSTITUTE(Table1[Header];" ";"")
and that seems to work.
/Johan
Hi yes was the order... thanks