Get value of max date

[maternmi]

Hello everybody,

I would like to get the Reason for change no. of the last (change) date. Below you can see the table

I've tried

= num(max({<Day>} Reason for change no.))

But it doesn't works

Can somebody help me?

Thank you in advance!

Best regards,

Michael

[#2 · Accepted solution]

in expression try this

FirstSortedValue([Reason for change no],-Day)

[#3]

try this

if(num(Day)=max(num(Day)),[Reason for change no.])

[saumyashah90]

This will get you max date value->

FirstSortedValue([ReasonForChange],-Day)

and This will get you min date value

FirstSortedValue([ReasonForChange],Day)