Forum Discussion
Anonymous
8 years agoNot applicable
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
- Anonymous8 years ago
Ok, solved the solution is
Date.ToText([#"Payment Date"],"MMM")