Forcing double digits in a table column

[Anonymous]

I have a calculated column in a table that returns values from 1 to 12. However I want them to be registered as 01, 02 etc. in double digits in the table. Please let me know if this is possible and how! Thanks!

[Anonymous]

Thanks, tried it but doesn't seem to work 🤷‍♂️

So here is the full story I guess - in the original data there is a column (text) called Period. It has values like 2019-1, 2019-2, 2019-3, ... , 2019-12. 

Now I split this column as per delimiter and got another column (text) called Period_Month. That has values like 1, 2, 3, ..., 12.

I transformed this text column into a number column. Now when I use the format function on it, it gives the same result and nothing changes!

[VahidDM · Accepted solution]

Hi @Anonymous 

Use FORMAT Dax function, try this code to add a new column:

Column = format([Value],"0#")

Output:

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/