How do I sort my dimension containing months in ascending order?

[mhapanka]

Hi team, I urgently require help on my dashboard. 

I am creating a dashboard from an attached csv file. I have a field called YearMonth that contains values like Jan-06,..,Mar-06, Apr-06,May-06 etc and so on till Dec-07.

I need to sort these in ascending order  so that they are in the order mentioned above rather than what can be seen in the picture. Could someone please help me out with the code for this?

Greatly appreciate your time on this,

Thanks

[Vince_CH]

Hello, I didn't see your picture, but I supposed the existing format was not in numerical format, hence you need to re-format it, please try the following in the load editor:
Date#(Year([field]) & '-' & Month([field]), 'MMM-YYYY') as MonthYear,

Option 2 is to use dual():
Dual(YearMonth, RIGHT(YearMonth,2)&NUM(LEFT(YearMonth,3))) as YearMonth,