Forum Discussion
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 ...
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