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
amitchandak
Super User
6 years agoText.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