Max Date / duplicate query

[knightwriter]

Hi All,

I have two fields, [Opportunity ID] and [updated Date]. As there can be multiple changes associated on one ID, I want to only pull the lastest Date listed with that ID.

If not, the same ID will be listed multiple times with a value amount that will be double counted. 

Im doing this in a straight table with chart properties and so can be done within the Dimensions or Expressions.

Could it be something like? All help much appreciated

=Max(Date(if( [Opportunity.ID] =  [Opportunity.ID],  [updated Date]))

[sunny_talwar · Accepted solution]

May be this as calculated dimension

Aggr(If([updated Date] = Max(TOTAL <[Opportunity.ID]> [updated Date]), [Opportunity.ID]), [Opportunity.ID], [updated Date])

[knightwriter]

nice one - worked a charm