Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

custom Index order - Calculated column

Hi

 

If someone could help me out how to create a calculated index column (DAX). I would like to use Cutoff date / Year Week as shown in the figure below.

 

I tried following ; Index2= RANKX(FILTER(Table;Table[cut_off]=EARLIER(Table[Cutoff];Table[cut_off];;ASC)

 

 

Thanks H.

 

 

Need Help

1 Reply

  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    Community Champion
    8 years ago

    Hi Anonymous

     

    Try this column

     

    Index =
RANKX ( Table, Table[CUTOFF],, ASC, DENSE )