Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to Solution.
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
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
@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?
User | Count |
---|---|
94 | |
80 | |
76 | |
65 | |
60 |
User | Count |
---|---|
108 | |
101 | |
77 | |
63 | |
61 |