Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello
how to rank this table based on start date excluding status = published
Workorder | Status | customer | start date | End Date |
One | published | abc | 01/08/2020 | 24/09/2020 |
two | reviewed | def | 24/09/2020 | 01/11/2020 |
three | waiting | xyz | 17/09/2020 | 12/01/2021 |
four | defered | abc | 01/12/2020 | 03/06/2021 |
five | published | oiu | 01/07/2020 | 23/12/2021 |
six | in progress | abc | 22/05/2019 | 01/09/2020 |
seven | in progress | def | 21/07/2019 | 21/08/2020 |
eight | in progress | kjs | 21/08/2019 | 12/11/2020 |
If the date are same ties needs to be broken using the end date
Regards
Solved! Go to Solution.
Hi @eden ,
Create a measure
Hi @eden ,
Hi @eden ,
Create a measure
@ harshnathani
Hi @eden ,
This is because your start date and end date for 2 rows are same.
Try adding RAND() to break the ties.
@eden , add a very small duration using random number generator and try
like rank on [End Date]+ time(0,0,RAND() )
refer this https://databear.com/how-to-use-the-dax-rankx-function-in-power-bi/
https://radacad.com/how-to-use-rankx-in-dax-part-3-of-3-the-finale
For Rank Refer these links
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures
https://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columns
https://community.powerbi.com/t5/Community-Blog/Dynamic-TopN-made-easy-with-What-If-Parameter/ba-p/3...
User | Count |
---|---|
101 | |
90 | |
80 | |
71 | |
70 |
User | Count |
---|---|
114 | |
98 | |
97 | |
73 | |
72 |