Forum Discussion

MP_123's avatar
MP_123
Microsoft Employee
9 years ago

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 O...
Need Help
MP_123's avatar
MP_123
Microsoft Employee
9 years ago

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's avatar
v-sihou-msft
Microsoft Employee
9 years ago

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's avatar
    MP_123
    Microsoft Employee
    9 years ago

    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's avatar
      MP_123
      Microsoft Employee
      9 years ago

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