Forum Discussion
Forcing double digits in a table column
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!
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/
2 Replies
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/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!