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

Power Query
1

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

2

@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.

Extended Date Table Cheat Sheet
Extended Date Table Cheat Sheet248×572 10 KB

2 Likes
3

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