Forum Discussion
Question regarding transforming a column to remove first character of entries if the value is 0
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.
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
3 Replies
- az38
Community Champion
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
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.
