Forum Discussion

Calcul8or's avatar
Calcul8or
Frequent Visitor
9 years ago

Rank by process and date selection

Hi,   I really hope someone can help me out with this problem.   I need to rank values by their inconsistent process names over a date range selection, as shown in the illustration below. The pro...
Need Help
v-sihou-msft's avatar
v-sihou-msft
Microsoft Employee
8 years ago

Calcul8or

 

In this scenario, I suggest you create a dummy column to combine Date and Order Step into numeric for ranking. 

 

You can add a column like below:

 

 

Rank Number =
1 * ( Table[Date] )
    * 1000
    + VALUE ( RIGHT ( Table[Order Step], LEN ( Table[Order Step] ) - 8 ) )

Then you can create a rank measure :

 

 

Rank =
RANKX (
    ALLSELECTED ( Table ),
    CALCULATE ( SUM ( Table[Rank Number] ) ),
    ,
    ASC,
    DENSE
)

Regards,