Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Year Sort

I've made a calculated column for Month and year and It's showing as below:   The sorting is not correct it seems. I want the Month and Year to be sorted.    Desired Output   Deal Mon...
Need Help
  • PhilipTreacy's avatar
    PhilipTreacy
    5 years ago

    Hi Anonymous 

    Create your column as actual dates and then they will sort properly.

    Try this to create the column

    Month Year = DATE(YEAR(VIEW_FORECASTREVENUE[EXPECTEDINMONTH]), VIEW_FORECASTREVENUE[Month], 1)

    You should get a column of type DateTime that should sort chronologically

    Regards

    Phil

  • jaideepnema's avatar
    jaideepnema
    5 years ago

    Hi Anonymous 
    You can create a numeric key like 202101 for January 2021 and then use this column for sorting the Month-Year column using the sort by column option.