Same result if you tried window_max function on this?
no luck with window_max either
Have you tried creating your field in the primary data source?
You could do something like this....
(DATETRUNC('month', ATTR([date])) =
DATETRUNC('day', ATTR([date])) <=
Thanks Steven. I tried that option and seems like it should work but doesn't quite get there. I checked (DATETRUNC('month', ATTR([date])) on its own and it returns a NULL for some reason. No cause I can discern.
The closest I have come to solving this is to back out the offset between max date in the primary source from Today() as below. It works, but only work when I hard code it. I was able to calculate the offset (e.g. Today()- [primary source]. [max date]) as an integer but again run into the problem of the formula not accepting the AGG calculation in an IF statement.
Any thoughts on how to write this to accept a calculation replacing Today()-12 or just the 12 below?
Appreciate everyone's feedback thus far or any other suggestions.
(DATETRUNC('month', [date]) =
DATETRUNC('day', [date]) <=
I thought there would be a calculation to solve this but in the end I just created a Units to Date extract that keeps in pace with the date range in the primary source using custom SQL. Blended that extract in the workbook as a separate data source and worked out perfectly.