Sorting Date

[niha]

Hi,

I need sorting of Yearmonth in Asc or Desc format.

This data contain 10 year and I want to limit it to 5 years like 2012 to 1017 Month Year.  In the following format I am not able to sort it Please help. YearMonth is autogenertaed calender. I need a YearMonth ASc or Desc order so that I can show trend of  a measure.  Either....2017Jan, 2017Feb................2017Dec, 2016Jan, 2016Feb so on .. or 201701,201702,....

My coding in Load Editor is

 Date(Date#([Date of Hire], 'M/D/YYYY') ) AS [DOH],
Year([Date of Hire]) as Year,
Month([Date of Hire]) as Month,

[lironbaram · Accepted solution]

hi 

for your year month you can use dual field 

which will include your text representation on the year month and numeric value 

something like : dual (YOUR_YEAR_MONTH_FIELD, monthstart([Date of Hire]) ) as YearMonth

[niha]

Hi,

Thanks. did not try as I got the field from data manager. But very helpful.

Thanks,

Niha