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
    5 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

v-janeyg-msft's avatar
v-janeyg-msft
Icon for Community Support rankCommunity Support
5 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