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

[pedroccamara]

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?
Thanks

[BrianJ]

@pedroccamara,

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.

[pedroccamara]

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