Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Calculated column max date

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...
Need Help
  • camargos88's avatar
    camargos88
    6 years ago

    Hi Anonymous ,

     

    Try this code for a calculated column:

     

    MaxDate = CALCULATE(MAX('Table'[Renewal date]); FILTER('Table'; 'Table'[Customer] = EARLIER('Table'[Customer])))
camargos88's avatar
camargos88
Community Champion
6 years ago

Hi Anonymous ,

 

Try this code for a calculated column:

 

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