Forum Discussion
Covert date to MMM and sort by date
Hi NewbieYR ,
A text column can be custom sorted by another column
To create a month sort column in DAX, you may use MONTH(Table[Date]).
In Power Query, go to Add Columns tab, highlight the dates column, go to Date then Month. This will create a column of month number where January is 1 and December is 12.
More info on custom column sort - https://radacad.com/sort-a-column-with-a-custom-order-in-power-bi
Hi,
If you have Month as a number in your column list, you could sort the particular column MMM based on the number month column.
Add the below code to create a new column in the table as a month number :
'Monthnumber = "Month",MONTH([Date table])'
then in your table click on the month column (MMM), then go to the menu and select 'Sort by Column' and in the drop-down menu, select 'Monthnumber' column :
then Short name of the month is sorted based on the number of month
Memorable MemberHi,
If you have Month as a number in your column list, you could sort the particular column MMM based on the number month column.
Add the below code to create a new column in the table as a month number :
'Monthnumber = "Month",MONTH([Date table])'
then in your table click on the month column (MMM), then go to the menu and select 'Sort by Column' and in the drop-down menu, select 'Monthnumber' column :
then Short name of the month is sorted based on the number of month