Forum Discussion
Dates Not in Chronological Order
Why can't I sort these in order?:
fhill I've figured it out now. Thanks! I created a formula and sorted it by the formula in my table:
YearMonthInt = 'Case'[Year]*100 + 'Case'[Month Number]
3 Replies
- fhill
Resident Rockstar
Under modeling, what's the Data Type of your 'Month & Year' measure? If it's Text, have you tried chaning it to a date format?
FOrrest
fhill I've figured it out now. Thanks! I created a formula and sorted it by the formula in my table:
YearMonthInt = 'Case'[Year]*100 + 'Case'[Month Number]
v-chuncz-msftCommunity Support
Anonymous,
Glad to hear that. You may help accept the solution above. Your contribution is highly appreciated.
