Forum Discussion

odzelashvili1's avatar
odzelashvili1
Helper I
4 years ago
Solved

RANKX issue

Hello PBI community 🙂   I want to solve this with RANKX function, but i dont get correct output.   My table looks like this: where I mannualy added "Rank" column, this is what I want to g...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    odzelashvili1 , Try a new column like

     

    rank = rankx(filter(Table, [visit_key] =earlier([visit_key]), [Time],,asc,dense)

     

     

amitchandak's avatar
amitchandak
Super User
4 years ago

odzelashvili1 , Try a new column like

 

rank = rankx(filter(Table, [visit_key] =earlier([visit_key]), [Time],,asc,dense)

 

 

odzelashvili1's avatar
odzelashvili1
Helper I
4 years ago

Thank you, I tried something similar, but doesnt worked, now its working.

 

I have another question, if I want to filter my table with more than 1 argument, can i use CALCULATETABLE function instead of filter?