returning a text value from set analysis

[Anonymous]

Have a table

Date                                      Process                Error

1/2/2016 5:10:00               ProcessA             invalid login

1/2/2016 6:10:00               ProcessA             invalid account

1/2/2016 6:15:00               ProcessA             Error in parameter

1/2/2016 6:16:00               ProcessB              Invalid acc

1/2/2016 7:01:00               ProcessA             Invalid Login

From the above table how to get the latest error message for Process A

[sunny_talwar · Accepted solution]

Try this:

FirstSortedValue({<Process = {'ProcessA'}>}Error, -Date)