Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Custom Column date formula

Hi All,

 

I am trying to create a custom formula to with a 3 digit month.

 

I am using the forumla = FORMAT([Payment Date],"mmm")

 

I am getting the following message "Expression Error : The name 'FORMAT' not recognised.

 

 

 
New to DAX, can someone help.
 
Many thanks
 
Herbz
  • Anonymous's avatar
    Anonymous
    8 years ago

    Ok, solved the solution is 

     

    Date.ToText([#"Payment Date"],"MMM")

9 Replies

  • Anonymous

    It's working fine for me. Make it as new column.

    • Anonymous's avatar
      Anonymous
      Not applicable

      Whats "DATEDATA"?

      • pxg08680's avatar
        pxg08680
        Resolver III

        Anonymous

        That's a sample table name. Sorry for confusing.