Forum Discussion

thedog123's avatar
thedog123
New Member
2 years ago
Solved

Latest Test Result

Hi All, I have been using PBI for a couple months now and have come across a problem that I'm having trouble with. I have some columns with these headings: Test Time (Datetime)| Test Result ...
  • vicky_'s avatar
    vicky_
    2 years ago

    Hey try this formula:

    Latest test result = CALCULATE(LASTNONBLANKVALUE('Table'[Test Time], MAX('Table'[Test Result])), ALLEXCEPT('Table', 'Table'[Identifier]))
vicky_'s avatar
vicky_
Icon for Super User rankSuper User
2 years ago

Hey try this formula:

Latest test result = CALCULATE(LASTNONBLANKVALUE('Table'[Test Time], MAX('Table'[Test Result])), ALLEXCEPT('Table', 'Table'[Identifier]))
thedog123's avatar
thedog123
New Member
2 years ago

Awesome, that worked. Thank you so much!