Firstsortedvalue - expression help

[#1]

Hi All,

I was wondering if someone could help me with a FirstSortedValue() expression.  I have create a simple FirstSortedValue() expression :

=FirstSortedValue([TM Event Value], -[TM Event Date])

This returns the Event value of the maximum date and does as it is suppose too.  However, I would like to add the condition '[TM Event Name] = 'Metal Wear Reading' to the FirstSortedValue() expression but I am not completely sure how to integrate it - should I use an aggr() or maybe include it in some set analysis.

Any help on this would be greatly apprectaited.

Many thanks,

Brian

[sunny_talwar · Accepted solution]

May be this:

=FirstSortedValue({<[TM Event Name] = {'Metal Wear Reading'}>}[TM Event Value], -[TM Event Date])

[#3]

Thanks Sunny that has seem to do the trick!

Much Appreciated - Brian