Last date as dimension

[patrou38]

Hello,

I would like to put as dimension a Date corresponding to the last one (Max(Date(CutOffDate))

but without success.

I tried this expression below, but something is probably missing 🙂

=if(date(CutOffDate)= max(date(CutOffDate)), date(CutOffDate)

Thank you for you help.

Patrick

[prieper]

try:

IF(CutOffDate = AGGR(MAX(CutOffDate), CutOffDate), DATE(CutOffDate))

Peter

[tresB · Accepted solution]

Try like:

=Aggr(if(Date(CutOffDate)= Date(Max( total CutOffDate)), date(CutOffDate), CutOffDate)

[patrou38]

Thank you very much, it works 🙂