Sort year ',' Month

[rockam]

Hi - Can I sort this [MonthYear] filter based on the newest to the oldest timeframe?

Code used:-

LOAD
[year],
[year]&','& Month(Date#([month],'M')) as [MonthYear],
[month],
[date],

Num#(XXXXX) as [XXXXX],

Month(Date#([month],'M')) as [MonthName] 

Any help or suggestion would be appreciated to sort the [MonthYear].

Thanks in Advance!

[Or]

Ideally, you should use MonthName(date) instead of string concatenation.

If you have to use string concatenation, you can use dual() to assign a matching date value, e.g.

dual([year]&','& Month(Date#([month],'M')),monthname(date)) as MonthYear