Forum Discussion

kattlees's avatar
kattlees
Post Patron
8 years ago
Solved

Rank Question

I have this rank column: Rank = VAR Symbol = V_ACCT[visit_mr_num] RETURN RANKX ( FILTER ( ALL ( V_ACCT ), V_ACCT[visit_mr_num] = Symbol ) , V_ACCT[Admit Date], , ASC )   See my screenshot ...
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    8 years ago

    Hi kattlees,

     

    I tested the above Rank formula on my side, it returned correct rank values as you can see in below image. It also display correctly when I add fields to table visual.

     

    Please provide more details about your source data.

     

    Regards,

    Yuliana Gu

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
8 years ago

Hi kattlees,

 

I tested the above Rank formula on my side, it returned correct rank values as you can see in below image. It also display correctly when I add fields to table visual.

 

Please provide more details about your source data.

 

Regards,

Yuliana Gu