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 th...
Hi Anonymous
Create this column for MMM/YYYY.
Column = Format(Table6[Date], "MMM / YYYY")
To help with sorting of this column.
create a Column
YearMonthInt = YEAR(Dates[Date])*100 + MONTH(Dates[Date]
https://community.powerbi.com/t5/Desktop/how-to-sort-Date-MonthYear-column/td-p/102700
Regards,
HN