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

[alevandenes]

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:

[v-jayw-msft]

Hi @alevandenes ,

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

Best Regards,

Jay

[Greg_Deckler · Accepted solution]

@alevandenes Use MIN and MAX?