Forum Discussion

grahamfletcher1's avatar
grahamfletcher1
Regular Visitor
8 years ago

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...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

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

grahamfletcher1's avatar
grahamfletcher1
Regular Visitor
8 years ago

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!

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    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