Forum Discussion

Walt1010's avatar
Walt1010
Helper V
2 years ago
Solved

Simple Data Sort Problem

202307 July  2023 202308 August  2023 202309 September  2023 202310 October  2023 202311 November  2023 202312 December  2023 202401 January  2024 202402 February ...
Need Help
Tips and Tricks
  • amitchandak's avatar
    amitchandak
    2 years ago

    Walt1010 , With Data I can see you should not face the issue 

     

    So if your Data is in MMMM YYYY or MMM YYYY format and sort it on YYYYMM format it should work

     

    Try creating the column again  like

     

    Month Year = FORMAT([Date],"mmmm yyyy")
    Month Year sort = FORMAT([Date],"yyyymm")

    or

     

    Month Year sort = year([Date]) *100 + month([Date]) 

     

    How to Create Sort Column and Solve Related Errors:
    https://www.youtube.com/watch?v=KK1zu4MBb-c

amitchandak's avatar
amitchandak
Super User
2 years ago

Walt1010 , With Data I can see you should not face the issue 

 

So if your Data is in MMMM YYYY or MMM YYYY format and sort it on YYYYMM format it should work

 

Try creating the column again  like

 

Month Year = FORMAT([Date],"mmmm yyyy")
Month Year sort = FORMAT([Date],"yyyymm")

or

 

Month Year sort = year([Date]) *100 + month([Date]) 

 

How to Create Sort Column and Solve Related Errors:
https://www.youtube.com/watch?v=KK1zu4MBb-c