Forum Discussion
Remove trailing 2 characters from end string
Hello, I am rather new to the M langauge and need some help. I have a column with strings that are either BFD###### or BF###### . I am looking to remove the last 2 characters from this strin...
Hi Anonymous ,
Based on my test, you could refer to below steps:
In power query:
Add a custom column and enter below code:
Text.Start([Data],Text.Length([Data])-2)
Result:
In dax, you could refer to below formula:
Column = LEFT('Table1 (2)'[Data],LEN('Table1 (2)'[Data])-2)Result:
You could also download the pbix file to have a view.
Regards,
Daniel He
Hi Anonymous
One thing you could try is going into the Power Query Editor and split the column after 7 characters and then deleting the column it creates from the split which would leave you with the column you are looking for. You can always go through and remove the applied steps in the editor if you need to revert it or are not satisfied with the outcome.
Scott