Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try these
=Max(Aggr(Maxstring(cert_attach),[Expiry Date2]))
or
=Maxstring({<[Expiry Date2]={"$(=MAX([Expiry Date2]))"}>}cert_attach)
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