Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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 h...
Need Help
  • VahidDM's avatar
    VahidDM
    4 years ago

    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/

     

     

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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!