Forum Discussion

saranee's avatar
saranee
Helper I
8 years ago
Solved

Dynamic ranking based on date

Hi all,   Request your help on this.   We are basically having a table with Name,Date and based on date we are assigning Rank. We have calculated column to calculate rank:RANKX(FILTER(Table1,Tab...
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    saranee

     

    Try this MEASURE for dynamic RANKING

     

    RANK =
RANKX (
    FILTER ( ALLSELECTED ( Table1 ), Table1[Name] = SELECTEDVALUE ( Table1[Name] ) ),
    CALCULATE ( SELECTEDVALUE ( Table1[Date] ) ),
    ,
    DESC,
    DENSE
)
ricardocamargos's avatar
ricardocamargos
Continued Contributor
8 years ago

Hi saranee,

 

Try this code:

 

_Index =
IF(ISBLANK(CALCULATE(COUNTROWS(Table2); FILTER(ALLSELECTED(Table2[Date]); Table2[Date] < MAX(Table2[Date]))));
1;
CALCULATE(COUNTROWS(Table2); FILTER(ALLEXCEPT(Table2; Table2[Name]); Table2[Date] < MAX(Table2[Date]))) + 1)

 

Ricardo

Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
8 years ago

saranee

 

Try this MEASURE for dynamic RANKING

 

RANK =
RANKX (
    FILTER ( ALLSELECTED ( Table1 ), Table1[Name] = SELECTEDVALUE ( Table1[Name] ) ),
    CALCULATE ( SELECTEDVALUE ( Table1[Date] ) ),
    ,
    DESC,
    DENSE
)
    • v-huizhn-msft's avatar
      v-huizhn-msft
      Microsoft Employee
      8 years ago

      Hi rishikdutta1987,

      Please mark the right solution as answer, so more people like you can find the solution easily.

      Best Regards,
      Angelia

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Zubair_Muhammad Thanks for the solution, it worked seamlessly. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Kudos on this solution