Date is not sorting chronologically

[Anonymous]

Hi Guys,

I have the following calculated column:

month-year = FORMAT(Sales[TimeStamp],"MMM-YYYY")

This works and produces my dates like feb-2021

What is not working is that they appear in the incorrect order:

instead of 

month-year	SalesVolume	SalesValue
Nov-20	345454	34545
Dec-20	34545	234344
Jan-21	874404	3.09E+09
Feb-21	949823	4.18E+09
Mar-21	843783	4535454
Apr-21	435554	233444

I get 

month-year	SalesVolume	SalesValue
Feb-21	949823	4.18E+09
Dec-20	34545	234344
Apr-21	435554	233444
Mar-21	843783	4535454
Nov-20	345454	34545
Jan-21	874404	3.09E+09

I don't see why this is happening? How can i get them to sort in chronological order? 

[Jihwan_Kim · Accepted solution]

Hi, @Anonymous 

One of many ways to sort it is to create one more column for the sorting purpose.

You can create one more column something like below.

Then, you can sort the month year column by the newly created column.

Month Year Sort CC =

EOMONTH(Dates[Date],0)

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM

[Anonymous]

This worked perfectly! Thank you so much for your help