Forum Discussion

okikuswanda's avatar
okikuswanda
Frequent Visitor
7 years ago
Solved

Concatenate IF Len With Quotaion Marks

Hello everyone.

 

Sorry, a new with Power BII have a column which a column value like this.

 

12233445566
14725836914
30104569

 

 

this value have LEN 11, and if i have Len Value is 7. i will concatenate this value with "000" ( or we usually call Quotation Marks )


Do you have any suggestions?

 

Thank you very much

Need Help
  • Mariusz's avatar
    Mariusz
    7 years ago

    Hi okikuswanda 

     

    You can add a custom column like below.

    Text.PadStart( Number.ToText( [id] ), 11, "0" )

    [id] - is your column name 

    Number.ToText() - converts number to text, remove this part if your column is a text data type
    Text.PadStart() - Pads text with "0"

     

     

    Best Regards,
    Mariusz

    If this post helps, then please consider Accepting it as the solution.

    Please feel free to connect with me.
    Mariusz Repczynski

     

1 Reply

  • Mariusz's avatar
    Mariusz
    Icon for Community Champion rankCommunity Champion
    7 years ago

    Hi okikuswanda 

     

    You can add a custom column like below.

    Text.PadStart( Number.ToText( [id] ), 11, "0" )

    [id] - is your column name 

    Number.ToText() - converts number to text, remove this part if your column is a text data type
    Text.PadStart() - Pads text with "0"

     

     

    Best Regards,
    Mariusz

    If this post helps, then please consider Accepting it as the solution.

    Please feel free to connect with me.
    Mariusz Repczynski