Is there a LastValueSorted

[Anonymous]

Hi Guys,

Like FirstSortedValue, is there a LastValueSorted as I need the lowest value rather than the first, or is there another way?

Thanks

[sunny_talwar · Accepted solution]

You can change the sort order

FirstSortedValue(Dim, -Date) -> 1st from the top

FirstSortedValue(Dim, Date) -> 1st from the bottom

[sushil353]

hi,

You can use + or - sign to reverse the sorting order like:

firstsortedvalue(Customer,-orderDate)

HTH

[shraddha_g]

firstsortedvalue(Dimension, -Measure)

It will give you last value

[Anonymous]

Thanks guys, I've got the answer now lol.