Remove Spacing from Text String

[Anonymous]

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 that does not seem to work... any ideas?

Thanks

[Johanno · Accepted solution]

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

[Anonymous]

Hi yes was the order... thanks