Forum Discussion
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 (Bool)| | Identifier (Text)| | Latest Test Result (should be a Bool) |
Each Identifier has several corresponding Test Times and Test Results. I am trying to find the latest test result for each identifier and put it into the Latest Test Result column for each identifier. An example of the expected output into the Latest Test Result column is given below:
| Test Time (Datetime)| | Test Result (Bool)| | Identifier (Text)| | Latest Test Result (should be a Bool) |
| 01-01-01 | False | a | False |
| 01-01-02 | True | a | False |
| 01-01-03 | False | a | False |
| 01-01-01 | False | b | True |
| 01-01-02 | True | b | True |
| 01-01-03 | True | b | True |
| 01-01-01 | False | c | False |
| 01-01-02 | False | d | True |
| 01-01-03 | True | d | True |
I have managed to get the date of the latest test, and have tried looking up the result using that value, but have had some trouble with function calls. Any help would be really appreciated.
Thanks
Hey try this formula:
Latest test result = CALCULATE(LASTNONBLANKVALUE('Table'[Test Time], MAX('Table'[Test Result])), ALLEXCEPT('Table', 'Table'[Identifier]))
