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...
Yeah I found the formatting within the modelling tab but as I was saying there isn't one for MMM and the shorthand month name and also no option for custom. How come no custom like Excel?
Can you try in a matrix, I've just checked and the other visuals do seem to handle it, however as a column in a matrix it gives the duplication. pbix isn't mine to share, could replicate it for you though if needed?
Thanks for your help!
grahamfletcher1,
You would need to use FORMAT() function, but format function will change the data type of column to Text.
I create a Matrix visual using Month2 Column, everything works well. Please share your PBIX file so that I can test.
Regards,
Lydia