armarillo7 Member

Thank you for the direct reference - I can't believe I didn't come across this article in my searches -_-

I am sure there was a much more straightforward way to achieve this but these are the steps I took: Create a constant max purchase date based on the CY 2. Then join the dataset output to the original dataset to create a new max column 3. Then finally create the CY & PY max columns in a new dataset output 4. Lastly, I was…

Hey @brycec thanks so much for the comment - you gave me a renewed sense of motivation to be able to use the max function in group by and I have played around a good bit. however it seems best to create a constant max date column with the latest date so I can use that column to subtract a year, but when I use max(date…