Unalble to trim spaces from the end of a string

[T-Pan]

Hello Everyone,

In power bi service i have crated a report from a "Power Aotomated File" located in Share Point, using Export to Power Bi. 

I have columns that contain strings with special characters such as ( " , { , [ , ]).

Using dax (substitute) i have created another column without the special characters in these values. 

But in my original Column i have two values:

["Maria "]

Maria

The above values in my new Column (free of special characters appear dublicated:

Maria

Maria

I suppose that  this value ["Maria "], in my new column have a space after the last charachter and this is the reason that i have the value two times in my new column.

I tried to "Trim" the new column but nothing happened.

Could anyone help me. I want to trim all spaces after the last character and before the first character.

Thank you.

[djurecicK2]

Hi @T-Pan ,

 You can use the TRIM function to accomplish this:

https://dax.guide/trim/#:~:text=%2D%2D%20TRIM%20removes%20trailing%20and,multiple%20spaces%20within%....

[arvindsingh802]

To clean the data from tab, space, next line, I will suggest to use Power Query's Clean & Trim step under Formate (Use both step)

Also perform this step after all your replace steps and at end you can use remove duplicate

[T-Pan]

I know that,

But I can't use transform Data, to go to Power Query, so i i want to find a solution using Dax.