cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MP_123 Member
Member

Months Order by

hi,

i have a slicer with months list, sorted on descending order

for example:

Dec

Nov
oct

same if it will be numbers:

12

11

10

the problem, now we are on January, the List is now

Dec Noc Oct Jan

i created a calculated column -if jan then 1 if dec then 2 etc... to sort it correctly

the problem is that i need to change this calculated column every new month

 

is someone have an idea how to sort it?

thanks!

6 REPLIES 6
tringuyenminh92 New Contributor
New Contributor

Re: Months Order by

Hi @MP_123,

 

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

MP_123 Member
Member

Re: Months Order by

hi @tringuyenminh92

what i meant is that:

if now we are on January so the calculated Column will be

Jan - 1

Dec - 2

Nov - 3

etc..., 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

 

 

tringuyenminh92 New Contributor
New Contributor

Re: Months Order by

Hi @MP_123,

 

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:

Screenshot 2017-01-18 20.01.22.png

 

Moderator v-sihou-msft
Moderator

Re: Months Order by

@MP_123

 

I think you suppose to have a month number column in your source table. You can add a rank column below:

 

Month Rank = 12 - Month(Today()) + Table[Month Number]

So the current month will be 12, previous month will be 11......

 

 

Then you just need to sort the Month Name based on above Month Rank in descending order.

 

Regards,

MP_123 Member
Member

Re: Months Order by

@v-sihou-msft

hi, thank you!

I actually don't understand

let's say we are in february

month rank = 12 - 2 +2 =12

but for January = 12 -2 +1 =11

Dec ? = 12 -2 + 12 = 22

 

the Sort isn't good that way. or am i missing something?

thanks!

MP_123 Member
Member

Re: Months Order by

i want that the rank of DEC will be 10... this month should come after january