Calculated column max date

[Anonymous]

How would I make a calculated column for Latest Customer Renewal Date in this case?

Customer	Product	Renewal date	Latest Customer Renewal Date (desired column)
A	Chair	4/15/20	4/20/20
A	Chair	4/20/20	4/20/20
B	Chair	5/2/20	5/10/20
B	Chair	5/10/20	5/10/20

[camargos88]

Hello @jack421 ,

Try this code for a computed column:

MaxDate á CALCULATE(MAX('Table'[Renewal date]); FILTER('Table'; 'Table'[Customer] - EARLIER('Table'[Customer])))

[camargos88 · Accepted solution]

Hi @Anonymous ,

Try this code for a calculated column:

MaxDate = CALCULATE(MAX('Table'[Renewal date]); FILTER('Table'; 'Table'[Customer] = EARLIER('Table'[Customer])))