Remove the last character if it is a letter

[Anonymous]

Hiya,

I would like to add a new column in PBI and only remove the last character if i is letter. Could you please help? Thanks

Original Column	New Column
1234A	1234
4321B	4321
6789D	6789
12345	12345

[Anonymous]

Thanks it works perfectly 🙂

[vicky_ · Accepted solution]

Try the following:

New Column = 
var ColumnLen = LEN('Table'[Column])
var lastCharacter = RIGHT('Table'[Column])
return IF(ISERROR(INT(lastCharacter)), LEFT('Table'[Column], columnLen - 1), 'Table'[Column])