Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
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
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.