Months Order by

[MP_123]

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!

[tringuyenminh92]

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]

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

[v-sihou-msft]

@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]

@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]

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

[tringuyenminh92]

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: