Latest Test Result

thedog123 — Fri, 03 Nov 2023 03:26:42 GMT

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

Re: Latest Test Result

vicky_ — Fri, 03 Nov 2023 04:01:21 GMT

Hey try this formula:

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

Re: Latest Test Result

thedog123 — Fri, 03 Nov 2023 04:24:17 GMT

Awesome, that worked. Thank you so much!

topic Latest Test Result in DAX Commands and Tips

Latest Test Result

Re: Latest Test Result

Re: Latest Test Result