cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Microsoft Employee

## 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
Memorable Member

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"?

Microsoft Employee

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

Microsoft Employee

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

Microsoft Employee

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

Microsoft Employee

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

Memorable Member

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:

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.