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,