Latest Test Result

[thedog123]

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

[vicky_ · Accepted solution]

Hey try this formula:

Latest test result = CALCULATE(LASTNONBLANKVALUE('Table'[Test Time], MAX('Table'[Test Result])), ALLEXCEPT('Table', 'Table'[Identifier]))

[thedog123]

Awesome, that worked. Thank you so much!