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
az38
Community Champion
6 years agoHi 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