Forum Discussion

Shawry's avatar
Shawry
Icon for Helper I rankHelper I
2 years ago
Solved

Order dates chronoligically by month

Hi,    I'm facing an issue in the new year, where Jan 2024 is displaying prior to my 2023 months, when looking at the past 6 months worth of data. See below:      The data is coming from t...
Need Help
  • Shawry's avatar
    Shawry
    2 years ago

    Thanks, I managed to sort it by created a new column which concatenated Month + Year, rather than using MonthName by itself. Cheers 🙂 

Shawry's avatar
Shawry
Icon for Helper I rankHelper I
2 years ago

Hi Ritaf1983 

 

Thanks for your reply. 

 

I have an Ascending sort order, based on Month Name. The 2023 months are dispalying fine, but Jan 2024 is not. I believe it has something to do with my Date table's Month Name column, being ordered based on the Month Number i.e. Jan = 1. 

 

 

Thanks. 

  • Shawry's avatar
    Shawry
    Icon for Helper I rankHelper I
    2 years ago

    Thanks, I managed to sort it by created a new column which concatenated Month + Year, rather than using MonthName by itself. Cheers 🙂 

    • Ritaf1983's avatar
      Ritaf1983
      Icon for Super User rankSuper User
      2 years ago

      Happy to help 🙂