Forum Discussion
Custom Date Format
I have a two parter around formating date fields for a matrix visual. 1) I have created a calculated column that uses the FORMAT function to create the date formatted as I need "MMM YYYY". This i...
grahamfletcher1,
Firstly, it is not possible to keep the calculated column "MMM YYYY" format and have it as a number. You can create another calculated column using formula: Month= Month(Table[Date]), then sort the first calculated column by this Month column. If you still get error, please post error message.
Secondly, you can create Month2 column using DAX below.
Month2 = IF('Table'[Control Date]>[ MaxSubmittedMonth],FORMAT('Table'[Control Date],"MMM YYYY"), FORMAT('Table'[Control Date],"MMM YYYY") & "*")
Regards,
Lydia