Month Sort Order Filter


Hi Everyone,

I have a question regarding the month sort order.

I am currently using the dates table function as supplied by Sam and this works great.

The issue i have is that when getting the month names, it sorts it alphabetically (See Screenshot)

I have attempted to go to the table and select the month name column and sort it by date. I then get an error as the month name does not have unique values.

What is best practice around this? Switch Statement or perhaps creating a table with all the month names in 1 column and then adding a numerical value to to sort in that order?

Thanks in advance.




You sorting by the incorrect column. You need to sort by MonthnYear (based on the date table code provided)


Thank You.

That worked out well.