Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be this:
=FirstSortedValue({<[TM Event Name] = {'Metal Wear Reading'}>}[TM Event Value], -[TM Event Date])
May be this:
=FirstSortedValue({<[TM Event Name] = {'Metal Wear Reading'}>}[TM Event Value], -[TM Event Date])
Thanks Sunny that has seem to do the trick!
Much Appreciated - Brian