Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
lottie2404
Frequent Visitor

HELP: Adding Leading Zeros in Power Query

Hello

How do I add "0" to a column that has 5 digits, the columns should have 6 digits, but due to an error it was loaded without the leading zero.

 

Could you explain me the process because I am new in power query, would I have to generate a new column? or modify the one I have?

2 REPLIES 2
v-cgao-msft
Community Support
Community Support

Hi @lottie2404 ,

 

I guess this column is automatically converted to an whole number type.

vcgaomsft_0-1679986883593.png

You can add a step to fix it by reconverting it to text type.

= Table.TransformColumns(#"Changed Type",{"Column1",each if Text.Length(Text.From(_))<6 then "0"&Text.From(_) else Text.From(_)})

vcgaomsft_1-1679986950564.png

Of course, if the column is of the correct type in the Source step you can unconvert it in the second step.

 

Best Regards,
Gao

Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

Anonymous
Not applicable

You can create a custom column (first make sure the column is changed to type text) using:

 

=Table.AddColumns(PriorStepOrTableName, {{"Padded", each Text.PadStart([NumberColumnName], "0", 1), type text}})

 

--Nate

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors
Top Kudoed Authors