Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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