Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to create a expression to find the last date within any selected period within the current year. Currently I have:
=max(Date(Year(Today())&GetFieldSelections([month])))
But this is returning a value with the year 2452 which is obviously not correct
Solved now thanks to a colleague:
=max({<[month code] = {$(=(Year(Today())&GetFieldSelections([month])))}>}[date])
Solved now thanks to a colleague:
=max({<[month code] = {$(=(Year(Today())&GetFieldSelections([month])))}>}[date])