How to find the minimum date for a specific event?

Hi,

I would like the minimum date for a specific event.
In that example, I would like to find the minimum date for the frozen date (e.g. March 14th), and use it in a formula.
First%20Date%20for%20Frozen%20ZoneFirst Date for Frozen Zone.morph (2.0 KB)
Any idea ?
Best Regards,
Michel

Hi Michel,

I would aggregate using the Min mode, then filtered only “Frozen zone”, then used Peek to bring the value back into the main table. See the modified example below:

First Date for Frozen Zone.morph (4.2 KB)

Thanks Dmitry,
I tried the min() function and I forget the aggregate transformation !!!
Brilliant as always !
Best,
Michel

You’re welcome!