Hello. Here I have a column that must contain numbers with 12 digits. However, sometimes I have 11 digits where 0 must be added in the front, so 0 + 11 digits. I changed the data type to text, even in that case 0 are removed from the data. How can I add 0 with measures or is it possible to do that if the length is less than 12, so 0 must be added to the beginning.
Hi @manap_98
Click into Model View then click on the column you want to format.
Under Formatting choose Format->Custom then enter 12 zeros as the format
Phil
If I answered your question please mark my post as the solution.
If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.
Hi @manap_98
Click into Model View then click on the column you want to format.
Under Formatting choose Format->Custom then enter 12 zeros as the format
Phil
If I answered your question please mark my post as the solution.
If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.
