Forum Discussion

UB40's avatar
UB40
Frequent Visitor
4 years ago
Solved

Help With RANKX

I'm very new to PowerBi and am looking for some help with the RANX function. I have a table, 'Result Grades', that needs to grouped as per the table below i.e 'RecNum', 'AcYr', 'Assessment', 'A8 Orde...
  • amitchandak's avatar
    amitchandak
    4 years ago

    UB40 , A new Rank Column

     

    RANKX(
    FILTER('Result Grades',
    'Result Grades'[RecNum] = EARLIER('Result Grades'[RecNum]) && 'Result Grades'[RecNum] = earlier('Result Grades'[RecNum]) &&
    'Result Grades'[AcYr] = earlier('Result Grades'[AcYr]) && 'Result Grades'[Assessment] = earlier('Result Grades'[Assessment]) &&
    [A8Order]="1"
    ),
    [ResultPts]
    ,,desc
    )

amitchandak's avatar
amitchandak
Super User
4 years ago

UB40 , A new Rank Column

 

RANKX(
FILTER('Result Grades',
'Result Grades'[RecNum] = EARLIER('Result Grades'[RecNum]) && 'Result Grades'[RecNum] = earlier('Result Grades'[RecNum]) &&
'Result Grades'[AcYr] = earlier('Result Grades'[AcYr]) && 'Result Grades'[Assessment] = earlier('Result Grades'[Assessment]) &&
[A8Order]="1"
),
[ResultPts]
,,desc
)