Calculated Dimension: How to retrieve the most recent date

[#1]

Hi,

I am trying to create a pivot table that includes a "Completed On" date column.

In my data set, i have many "Completed On" dates to one "SID" (Unique identifier).

How do i create a calculated dimension that gets the most recent date from the "Completed On" column? Currently, SID 114381 is retrieving 14/10/2014, but i want it to retrieve 17/10/2014. How is this possible?

Thanks,

Matt

[jonathandienst]

Hi

=FirstSortedValue([Completed On], -[Completed On])

HTH

Jonathan

[jagan · Accepted solution]

Hi,

Try this as Calculated Dimension

=Aggr(Max([Completed On]), SID)

Regards,

Jagan.

[#4]

Hi Jonathan,

Thanks for the quick reply.

Getting an error.

If i put your formula into the expression of a table box , it comes up with these numbers, i'm not sure what they mean, maybe you can shed some light on it.

Thanks,

Matt

[jagan]

Hi Matt,

Convert the format to Date like below calculated dimension

Date(FirstSortedValue([Completed On], -[Completed On]))

Regards,

Jagan.