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