Forum Discussion
Change Date format to MMM/YYYY
I am looking to change my date format to MMM/YYYY. This is not an option an existing data format option. I have tried creating the below calculated column, but it changes the data type to text and then does not sort my charts according to date and my date filters would no longer apply. I am looking for a way to change the format to MMM/YYYY, while keeping the data type as date.
Column = FORMAT('Date], "MMM YYYY")
3 Replies
- Fowmy
Super User
Anonymous
Select your date column and directly enter simple letters formating string as shown belowAdditionally, use the same when you add columns with FORMAT.
COLUMN = FORMAT('Date], "mmm yyyy")________________________
Did I answer your question? Mark this post as a solution, this will help others!.
Click on the Thumbs-Up icon on the right if you like this reply 🙂
- FrankAT
Community Champion
Hi Anonymous,
the function FORMAT() returns a string. You can set the desired format in model view:
- Select the date column.
- In properties pane open date time format and choose Custom.
- Set your desired date format to mmm yyyy and press Enter.
That's is
Regards FrankAT
Hi Anonymous
Create this column for MMM/YYYY.
Column = Format(Table6[Date], "MMM / YYYY")To help with sorting of this column.create a ColumnYearMonthInt = YEAR(Dates[Date])*100 + MONTH(Dates[Date]https://community.powerbi.com/t5/Desktop/how-to-sort-Date-MonthYear-column/td-p/102700
Regards,
HN
