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 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