Forum Discussion
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 |
| A | Chair | 4/20/20 | 4/20/20 |
| B | Chair | 5/2/20 | 5/10/20 |
| B | Chair | 5/10/20 | 5/10/20 |
Hi Anonymous ,
Try this code for a calculated column:
MaxDate = CALCULATE(MAX('Table'[Renewal date]); FILTER('Table'; 'Table'[Customer] = EARLIER('Table'[Customer])))
2 Replies
Hi Anonymous ,
Try this code for a calculated column:
MaxDate = CALCULATE(MAX('Table'[Renewal date]); FILTER('Table'; 'Table'[Customer] = EARLIER('Table'[Customer])))Hello @jack421 ,
Try this code for a computed column:
MaxDate á CALCULATE(MAX('Table'[Renewal date]); FILTER('Table'; 'Table'[Customer] - EARLIER('Table'[Customer])))