Forum Discussion
Solved
Add leading zeros to text in Power Query
Hi all I need to replicate the following excel formula in power query: Here is my power query column: I tried: Error came in: How can i f...
Text.PadStart([#"[BPP CODE]"], 10, "0")
The data is already in the correct format. Just change column type to text so that the leading zeros are not removed upon load.
Table.TransformColumnTypes(Source,{"BPP Code", type text})