Forum Discussion

Jolyon's avatar
Jolyon
Icon for Helper III rankHelper III
9 years ago

how to sort Date (MonthYear column)?

Hello, need urgent help of yours:   I have a column Date (e.g. 01.01.2016), then I added columns Month and Year and concatenated them to get the column MonthYear(e.g. January2016):     No...
Need Help
tringuyenminh92's avatar
tringuyenminh92
Icon for Memorable Member rankMemorable Member
9 years ago

Hi Jolyon,

 

In case you want to sort by Year and Month of date, you could add Calcuated column for YearMonthInt as:

YearMonthInt = Dates[Date].[Year]*100 +  Dates[Date].[MonthNo]

Then choose MonthYear column and choose sort by YearMonthInt column.

 

 

If this works for you please accept it as solution and also like to give KUDOS.

Best regards
Tri Nguyen

Anonymous's avatar
Anonymous
Not applicable
6 years ago

 This worked for me!  Thanks!