How to add index based on month and year combined- to sort month in asc order

[shankarshiva70]

Hello everyone,

I want to sort below month'Year in asending order. 

I am not able to sort. please help on this.

Used already-Created monthNo & sorted on and got result correct for only year but not for more than 1 year as it has more than 1 year like in above view .

I don't have to plot year above month row in view.

Thanks

Shiv

[TarunSharma]

Hello @shankarshiva70 ,
Create MonthYearInteger column 
MonthYearInteger = 

CONCATENATE( 'Calendar'[Year], RIGHT("0" & 'Calendar'[Month Number], 2) )

Sort the MonthYear column by MonthYearInteger.

[shankarshiva70]

Hi Tarun, 

Thanks for reply

I have done this by this way

Created one column 

MonthYearSort = FORMAT(Dates[Date],"YYYYMM")

Month'Year=Format(Dates[Dates],"MMM'YY")

then goto Sort by > click on monthyearsort then output will be correct.

Thanks

Then

[shankarshiva70]

Hi Tarun, 

I have done this using @amitchandak post. but thanks for reply you r also corect 

[Fowmy]

@shankarshiva70 


You need to create the sort column including the year, modify monthno column as follows, and sort by that:

YearMonth = YEAR(Dates[Date]) * 100 + MONTH(Dates[Date])

________________________

If my answer was helpful, please click Accept it as the solution to help other members find it useful

Click on the Thumbs-Up icon if you like this reply 🙂

Website YouTube  LinkedIn

[shankarshiva70]

Thanks for reply

I have done this by this way

Created one column 

MonthYearSort = FORMAT(Dates[Date],"YYYYMM")

Month'Year=Format(Dates[Dates],"MMM'YY")

then goto Sort by > click on monthyearsort then output will be correct.

Thanks

Then