Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

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

1 ACCEPTED SOLUTION
Johanno
Responsive Resident
Responsive Resident

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

View solution in original post

2 REPLIES 2
Johanno
Responsive Resident
Responsive Resident

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
Not applicable

Hi yes was the order... thanks

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.