Dates Not in Chronological Order

[Anonymous]

Why can't I sort these in order?:

[fhill]

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

[Anonymous · Accepted solution]

@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-msft]

@Anonymous,

Glad to hear that. You may help accept the solution above. Your contribution is highly appreciated.