Dates in chronological order

[Kolumam]

Hi All,

See the below pic. How do I sort this issue and make it from Jan 2015 to Dec 2015, followed by....Jan 2016..

Kindly help.

Thanks

Krishna

[Anonymous]

It looks like your data is of type "Text" instead of "Date", is that correct?

[Kolumam]

Hi Ross,

I changed it to date but when I try to change it, it shows me this error ?

How do I rectify this ?

Thanks

Krishna

[Anonymous · Accepted solution]

You'll need to change the measure such that you are recording a date.  I'd recommend using:

YearMonth = DATE([Year], [Month], 1)

Under Modelling, set the DataType as "Date" and Format to be "March 2001(MMMM yyyy)"

EDIT:  The measure above assumes your Month and Year are columns.  If not, take your Date field and use YEAR([DateField]) and MONTH([DateField])

[Kolumam]

Thanks a ton ! @Anonymous