Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Date Order

Currently, my order look so;   2018 W1 2018 W10 2018 W11 . . 2018 W2 2018 W21 2018 W22 . . I want 2018 W1,2,3,4,5,6 . . . 2019 W1,2,3,4,5 . . . any ideas how to do?           ...
Need Help
  • v-cherch-msft's avatar
    v-cherch-msft
    7 years ago

    Hi Anonymous

     

    Please check the rank column.Make sure it is ranked by YearWeek column.Then use sort by column.

    Rank = RANKX(Table3,Table3[YearWeek],,ASC,Dense)

    Regards,

    Cherie

Anonymous's avatar
Anonymous
Not applicable
7 years ago

I followed your advice.

then i've got an error message saying like the pic below.

i am not sure what the problem is..!

v-cherch-msft's avatar
v-cherch-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

Hi Anonymous

 

Please check the rank column.Make sure it is ranked by YearWeek column.Then use sort by column.

Rank = RANKX(Table3,Table3[YearWeek],,ASC,Dense)

Regards,

Cherie