Forum Discussion
jimmart
6 years agoRegular Visitor
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 ...
- 6 years ago
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
jimmart
6 years agoRegular Visitor
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.