topic Show single value of dimension where date =max(date) in App Development

Show single value of dimension where date =max(date)

davyqliks — Wed, 14 Sep 2022 11:31:50 GMT

Hi All.

I have the following expression which is giving data for the max Date

Max(Date([Expiry Date2],'DD/MM/YYYY')).

when i add a new field to the table (cert_attach) i get the max date for all of the certs (which all have individual values)

How can i write an expression please to only show the relevant cert_attach (scope certificate) for only the max date.

when i try the following as a measure i am getting null return.

If([Expiry Date2] = Max(Date([Expiry Date2],'DD/MM/YYYY')),cert_attach)

thank you

BrunPierre — Wed, 14 Sep 2022 12:37:50 GMT

Try these

=Max(Aggr(Maxstring(cert_attach),[Expiry Date2]))

=Maxstring({<[Expiry Date2]={"$(=MAX([Expiry Date2]))"}>}cert_attach)

davyqliks — Wed, 14 Sep 2022 13:03:36 GMT

Thank you for the suggestion,

i have found there is another value in the data forcing the cert over multiple lines. Factory Profile.

so in theory what i have is the unique cert for the max date.

I need the measure to be a dimension. so when i use your version here with Aggr()

=Aggr(Maxstring({<[Expiry Date2]={"$(=MAX([Expiry Date2]))"}>}cert_attach),[Expiry Date2])

It looks correct but only shows the max record once i un filter everything. so this will not work.

Really appreciate your help, thanks

Daniel