Forum Discussion

brettg's avatar
brettg
Icon for Helper II rankHelper II
8 years ago

Latest Value - By Date

  Hi All,   I would like to create an IF measure for my 'Grade' column so I can add a new column next to grade called 'Latest grade'   I would like this measure to take the latest grade per indi...
Need Help
  • brettg's avatar
    brettg
    Icon for Helper II rankHelper II
    8 years ago

    Hi v-chuncz-msft

     

    Thanks for your reply.

     

    I have had a look at the 'RANKX' post, but I'm not sure how I can get this to work for my grade column?

     

    I would need the rank to be by distinct user and latest test date, would this be possible?

     

    Thanks,

    Brett