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.

PhilipTreacy's avatar
PhilipTreacy
Super User
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

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Can you please show what actually you mean by "Actual dates". It is not clear to me.

     

    Regards

    • PhilipTreacy's avatar
      PhilipTreacy
      Super User
      5 years ago

      Anonymous 

      Just added an example of how to create the dates based on your data.

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

       

      Regards

      Phil

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Thank you !!!

     

    It resolved my issue.

     

    Regards,

    Himanshu