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? the table that i want to reproduce looks like this:

 

 

 

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi alevandenes ,

     

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

     

    Best Regards,

    Jay