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,
You can change format of date column as shown in the following screenshot.
The DAX works well in my PBIX file. Would you mind sharing me your PBIX file so that I can test? You can send me PBIX file via private message,
Regards,
Lydia
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!