Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

DAX Query to Change Date Format Not Working

By browsing through previous forums, I tried to change a column containing only numbers as months, and utilized a dax query to create a new column: the following is the dax query that I tried to use 

 

FORMAT('Table'[Column],"MMM")

 

When I do this however, the attached screenshot below occurs:

 

 

Any help would be greatly appreciated

Need Help

1 Reply

  • HotChilli's avatar
    HotChilli
    Community Champion
    7 years ago

    You have to pass a Date to that version of FORMAT. You are just passing an integer.

     

    Edit : There may be a way of doing it by constructing a 'dummy' date and using the integer passed as the month