Forum Discussion

o59393's avatar
o59393
Icon for Post Prodigy rankPost Prodigy
4 years ago
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 fix it?

 

Thanks.

Need Help
Show and Tell

3 Replies

  • CNENFRNL's avatar
    CNENFRNL
    Icon for Community Champion rankCommunity Champion
    4 years ago

     

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

     

  • zat0na's avatar
    zat0na
    New Member
    2 years ago

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