Question regarding transforming a column to remove first character of entries if the value is 0

[jimmart]

Hi Guys,

Quite new with PowerBI and just wondering how i can achieve this.

I have a table where a column is existing which is telephone number, now this column is basically a text (dont wish to convert it to integer\number since there are some entries which are texts)

Basically there are some entries which starts with 0 for example. 0123456, I would like it to transform to 123456 while for entries that doesnt start with 0 to just leave it as it is.

Picture of what I would like to achieve.

I have tried to use after delimeters but it would then take out whats after the subsequent 0's.

[jimmart]

Thanks Guys for the suggestions @amitchandak  @az38 

Ultimately the one that fixed it was the link shared by @az38  thanks again guys for your help.

[az38 · Accepted solution]

Hi @jimmart 

try to use this technique https://www.absentdata.com/power-bi/remove-leading-zeros-power-bi/ just to set data type as whole number

[amitchandak]

@jimmart 

Text.trim can help you in M

https://www.absentdata.com/power-bi/remove-leading-zeros-power-bi/

https://community.powerbi.com/t5/Desktop/Remove-leading-Zero-s-in-Query/td-p/247410