Months Order by

Question

hi,i have a slicer with months list, sorted on descending orderfor example:DecNovoctsame if it will be numbers:121110the problem, now we are on January, the List is nowDec Noc Oct Jani created a calculated column -if jan then 1 if dec then 2 etc... to sort it correctlythe problem is that i need to change this calculated column every new month&nbsp;is someone have an idea how to sort it?thanks!

tringuyenminh92 · Answer

Hi&nbsp;MP_123,&nbsp;You could create condition column in Query Editor for 12 months, but i dont understand "change this calculated column every new month"?

mp_123 · Answer

hi tringuyenminh92what i meant is that:if now we are on January so the calculated Column will beJan - 1Dec - 2Nov - 3etc..., Feb will be 12 because it will be the last.but when we will get to February, its value should be 1, Jan 2 and Dec 3&nbsp;&nbsp;

tringuyenminh92 · Answer

Hi&nbsp;MP_123,&nbsp;I don't know what you are doing with your if statement or first or last or anything, but let me show it as below:&nbsp;

v-sihou-msft · Answer

MP_123
&nbsp;
I think you suppose to have a month number column in your source table. You can add a rank column below:
&nbsp;
Month Rank = 12 - Month(Today()) + Table[Month Number]
So the current month will be 12, previous month will be 11......
&nbsp;
&nbsp;
Then you just need to sort the Month Name based on above Month Rank in descending order.
&nbsp;
Regards,

mp_123 · Answer

v-sihou-msfthi, thank you!I actually don't understandlet's say we are in februarymonth rank = 12 - 2 +2 =12but for January = 12 -2 +1 =11Dec ? = 12 -2 + 12 = 22&nbsp;the Sort isn't good that way. or am i missing something?thanks!

Forum Discussion

Months Order by

6 Replies

Related content

sorting months in order

Omitting months with Firm Orders

Month Name in sorting order

Months in wrong order

Months alphabetical order