Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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...
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
88 | |
82 | |
66 | |
64 | |
57 |
User | Count |
---|---|
171 | |
111 | |
109 | |
72 | |
71 |