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/

     

     

VahidDM's avatar
VahidDM
Super User
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/