Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys
i have expression which select the lowest date - >
date(min(WeekStart([Start Plan]))+7, 'DD-MM-YYYY') which gives 02-02-2020,
and i want to select only value which match mentioned date = 20.2.
My example doesn't work 😞
=Only({<[Start Plan] = {"=date(min(WeekStart([Start Plan]))+7, 'DD-MM-YYYY')"} >} [IterationLevel5])
Try with a small tweak, like:
=Only({<[Start Plan] = {"$(=date(min(WeekStart([Start Plan]))+7, 'DD-MM-YYYY'))"} >} [IterationLevel5])