Forum Discussion
Date is not sorting chronologically
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?
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
2 Replies
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