DAX: Apply trim (or any string function) to entire column

[lpriceFTW]

I want to trim the contents of an entire column in DAX.

It is a measure table, so I did not create this in PowerQuery M.

Does the ability exist within DAX to do this?

Example:

Original Table:

Header

my text

my    text

this text

text    my

After Trim Table:

Header

my text

my text

this text

text my

[Anand24 · Accepted solution]

Hi @lpriceFTW ,
I guess Power BI automatically trims the values to eliminate additional spaces anywhere. 
Just in case it doesn't, you can use TRIM function like below DAX:

1. For a trimmed new calculated column:

Trimmed Header = TRIM('Table'[Header])

2. For a trimmed new calculated measure:

Trimmed Header = TRIM(MAX('Table'[Header]))

Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!! Proud To Be a Super User !!! LinkedIn

[Uzi2019 · Accepted solution]

Hi @lpriceFTW 
PBI auto Trim the white space in the column.I have taken your data.

when I take the data in visual / table then it auto display the values without white space.

Or if still is it there you can take TRIM() in measure like below.

Trim Header = TRIM(MIN('Trim Table'[Header]))

It gives the same result. 

I hope I answered your question!

[lpriceFTW]

Hey thanks for the reply.

I ended up just creating a calculated column on the untrimmed measure table like you mentioned. I used the calculated trim column for my table relationships.

[v-shex-msft]

Hi @lpriceFTW ,

Did the above suggestions help with your scenario? if that is the case, you can consider Kudo or Accept the helpful suggestions to help others who faced similar requirements.

If these also don't help, please share more detailed information and description to help us clarify your scenario to test.

How to Get Your Question Answered Quickly 

Regards,

Xiaoxin Sheng

[Anand24 · Accepted solution]

Hi @lpriceFTW ,
I guess Power BI automatically trims the values to eliminate additional spaces anywhere. 
Just in case it doesn't, you can use TRIM function like below DAX:

1. For a trimmed new calculated column:

Trimmed Header = TRIM('Table'[Header])

2. For a trimmed new calculated measure:

Trimmed Header = TRIM(MAX('Table'[Header]))

Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!! Proud To Be a Super User !!! LinkedIn

[lpriceFTW]

Hey thanks for the reply.

I ended up just creating a calculated column on the untrimmed measure table like you mentioned. I used the calculated trim column for my table relationships.