Forum Discussion

alevandenes's avatar
alevandenes
Icon for Helper IV rankHelper IV
5 years ago
Solved

Create table from existing data with earliest start date and latest end date

Hi,   i would like to create a table from existing data with the SUMMARIZE function, using formulas like EARLIEST and LATEST. However, LATEST is not an option with SUMMARIZE. Any other suggestion? ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi alevandenes ,

 

As Greg said you could use MAX() and MIN() function to get the latest and earliest date.

 

Best Regards,

Jay