Forum Discussion

Icon for Helper II rank

Helper II

4 years ago

Solved

Delete numbers

Hi, I want to delete the number '0' before the integers. Thanks!

Anonymous
4 years ago
Hi dolevh ,

Try to add a custom colum in power query

= Text.TrimStart([Column1],"0")

Reference: Remove Leading Zeros from Text in Power Query - YouTube

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
test1.pbix23 KB

Icon for Super User rank

Super User

4 years ago

The simplest solution is probably to convert the column to a whole number data type instead of text.