Sorry, a new with Power BII have a column which a column value like this.
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
Go to Solution.
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 typeText.PadStart() - Pads text with "0"
View solution in original post
Join us in the third Triple A event!
It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.
Make sure you didn't miss any of the things that happened in the community in January!