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.
For Month Name, try sorting by MonthOfYear, not MonthNYear.
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!!!