Forum Discussion
ThiagoDuarte
Helper I
Helper IRank with groups and duplicates
Hello guys, I need some help with a rank column This is what I have: I need to rank rpr column inside every rpf value rpf is a report id and every rpr is a sample inside the report...
Hi ThiagoDuarte ,
How about this:
I used the following code to create a calculated column:
TomsRankColumn = RANKX ( FILTER ( Table, Table[rpf] = EARLIER ( Table[rpf] ) ), Table14[rpr], , ASC, DENSE ) - 1Does this work for you? 🙂
/Tom
https://www.instagram.com/tackytechtom
tackytechtom
Most Valuable Professional
Most Valuable ProfessionalHi ThiagoDuarte ,
How about this:
I used the following code to create a calculated column:
TomsRankColumn =
RANKX (
FILTER ( Table, Table[rpf] = EARLIER ( Table[rpf] ) ),
Table14[rpr],
,
ASC,
DENSE
) - 1
Does this work for you? 🙂
/Tom
https://www.instagram.com/tackytechtom