Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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"
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"
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.