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
8 years ago

Hi tringuyenminh92 I am having this kind of data in reports and also wnat to sort as same Jolyon sorting for his reports 

means if multiple years data we have first it will sort by year in that case . But how to prepared calculate colum for above scenario as per above data. help me here i am new to DAX querys. also not having date column in my all tables so please suggest me how to achive that sorting on multiple year data