Dates are not ordered chronologically, It is mixed

[Anonymous]

I have date formats in the text format like 

Jul-20

Aug-20

Sep-20

Oct-20

Nov-20

Dec-20

Jan-21

:::::: 

feb-21

......So on till Dec-21

I have used custom ordering, used month orders, still I am facing problems.

Could you please help me with this? Pls

[amitchandak · Accepted solution]

@Anonymous , In you date table you have month year

Month Year = FORMAT([Date],"mmm-yyyy")

Create a new column
Month Year sort = FORMAT([Date],"yyyymm")

Mark this as sort column from column tools

How to Create Sort Column and Solve Related Errors: https://youtu.be/KK1zu4MBb-c

[amitchandak · Accepted solution]

@Anonymous , In you date table you have month year

Month Year = FORMAT([Date],"mmm-yyyy")

Create a new column
Month Year sort = FORMAT([Date],"yyyymm")

Mark this as sort column from column tools

How to Create Sort Column and Solve Related Errors: https://youtu.be/KK1zu4MBb-c

[Anonymous · Accepted solution]

Thank you amit!!!. That sorted my problem.