topic How to add index based on month and year combined- to sort month in asc order in DAX Commands and Tips

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

Anonymous — Sat, 16 Jan 2021 11:40:56 GMT

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

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

Fowmy — Sat, 16 Jan 2021 11:51:43 GMT

Anonymous

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

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

Anonymous — Mon, 18 Jan 2021 13:35:13 GMT

Hello Anonymous ,
Create MonthYearInteger column
MonthYearInteger =

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

Sort the MonthYear column by MonthYearInteger.

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

Anonymous — Mon, 18 Jan 2021 18:41:38 GMT

Hi Tarun,

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

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

Anonymous — Mon, 18 Jan 2021 18:45:52 GMT

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

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

Anonymous — Mon, 18 Jan 2021 18:46:39 GMT

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