Extended Date Table (Power Query M function) sort by monthnyear not working

Hey guys,
I’m using this table above to link to my fact table for quite a while.
Suddenly i can’t sort order the month name by the monthnyear column.
Anything wrong?


For Month Name, try sorting by MonthOfYear, not MonthNYear.

  • Brian

P.S. I find this cheat sheet really helpful in figuring out what fields to sort by what.


you’re the man @BrianJ
Thank you so much!!!