Forum Discussion

learner03's avatar
learner03
Icon for Post Partisan rankPost Partisan
5 years ago
Solved

Double Sort

How can sort below by Picking first...then Ready and then Allocated. Also, the second sort by Job create time from ascending to decending. I mean where the job status will be picking, there time woul...
Need Help
  • v-janeyg-msft's avatar
    v-janeyg-msft
    4 years ago

    Hi, learner03 

     

    You need to create two column to show the sort results you want.

    Like this:

    Column = IF(Table1[job status]="Picking",1,IF(Table1[job status]="Ready",2,3))
    rank = RANKX(Table1,RANKX(Table1,[Column],,DESC)*1000+RANKX(Table1,[jbo create time],,ASC,Dense))

    Reference:

    RANKX function (DAX) - DAX | Microsoft Docs

     

    Did I answer your question ? Please mark my reply as solution. Thank you very much.
    If not, please feel free to ask me.


    Best Regards,

    Community Support Team _ Janey

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

learner03 , In the table visual you can click on another column with shift and sort that too.

Click on the column, what you want to sort , once or twice. Then press shift and click on another one

  • learner03's avatar
    learner03
    Icon for Post Partisan rankPost Partisan
    5 years ago

    amitchandak Fowmy  If I click on Status  coloumn, then it sort alphabatically. But, I want it to be by Picking..Ready ..Allocated. How can I do that?