[Month Year] Sort Help

[rxp03570]

Hi,

Trying to sort [Month Year] data is in the form 2016 Jan.....2017 Jan... 2018 Jan.

Thanks for the help 🙂

[sunny_talwar]

May be try sorting using this expression

Month([Month Year])*100000 + Year([Month Year])

[MK_QSL · Accepted solution]

Or sort by expression as below

Date#([Month Year],'YYYY MMM')

[sunny_talwar]

I might have misunderstood... but this will sort like this

Jan 2016

Feb 2016

Mar 2016

.

.

.

Dec 2016

Jan 2017

Feb 2017

Mar 2017

.

.

.

Dec 2017

Jan 2018

.

.

.

From what I understood, the sorting needed is like this

Jan 2016

Jan 2017

Jan 2018

Feb 2016

Feb 2017

Feb 2018

.

.

.

If the above is not what is needed then I would use mrkachhiaimp‌'s expression for sure

[sunny_talwar]

I guess I was wrong