Concatenate IF Len With Quotaion Marks

[okikuswanda]

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

[Mariusz · Accepted solution]

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.