Forum Discussion
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 would be Asc to Dsc...and so on.
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
3 Replies
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
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?
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
