Add leading zeros to text in Power Query

[o59393]

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 fix it?

Thanks.

[zat0na]

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})

[CNENFRNL · Accepted solution]

Text.PadStart([#"[BPP CODE]"], 10, "0")

[o59393]

Thanks!