Date not sorting by Year then Month - updated to include pBIX

[littlepatos]

I have a line chart visual that I need to sort via Year and Month so it should be Sept 2020, Oct 2020, Nov 2020, Dec 2020, Jan 2021, Feb 2021 etc

I created a new table to abbreviate the Month names (from Septembre to Sep) and have joined this to my date table. 

I am sorting by Year Month Abbrev Ascending

https://drive.google.com/file/d/1lsGVhogTsHzMsmzFqUpMk0YFTBJYFpUT/view?usp=drivesdk

https://docs.google.com/file/d/1etwKFEKKxP9BbTrIpnqUYXi3PkMRsdSH/edit?usp=docslist_api&filetype=msex...

[littlepatos · Accepted solution]

I've added a month number then used the Column sort to define sort order and this worked

[littlepatos]

I have a column for month number but it only goes to 12 where I think I need it to go to 24? 

I tried a few methods to correct such as "Month Number", (YEAR([Date])-YEAR(MIN([Date]))) * 24 + MONTH([Date]) but this doesn't work.