Sort by Column Error

[seenai]

Hi,

I have Date table with Column in MMM format (Jan / Feb etc).

I could not sort the month by Date Order. Help me if possible.

[amitchandak]

@seenai 

Column and Sort column should have the same granularity. So the only sort column you can use is

Sort Month = format(Date[date],"MM")

[seenai]

Hi

@amitchandak 

I have added a New Column as below :

Sort Month = format(Month_Year[Date],"MM")

It is giving result as 01, 02, 03, etc.

But I would like to show as Jan, Feb, Mar, Apr etc.

Please let me know, if any other control is there to sort the 

[v-gizhi-msft · Accepted solution]

Hi,

Please try these:

T_Month = FORMAT('Table'[Date],"MMM")

MonthNo = FORMAT('Table'[Date],"MM")

Then you can sort [T_Month] by [MonthNo].

Best Regards,

Giotto

[seenai]

@amitchandak  & @v-gizhi-msft 

Thanks for your quick support and clarification.

My Learning : 
To sort Month in MMM format. I need a column in MM format.

Similarly

To sort Month in MMM-YY format. I need a column in YYYYMM format.