Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

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

 

Thanks

Need Help
  • Johanno's avatar
    Johanno
    8 years ago

    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

2 Replies

  • Johanno's avatar
    Johanno
    Continued Contributor
    8 years ago

    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's avatar
      Anonymous
      Not applicable
      8 years ago

      Hi yes was the order... thanks