Hello - I am seeking assistance on my use case below:
In my data set:
I have one column "REDEMPTION MONTH" which represents the month that a customer redeemed a prize. (customer can have multiple redemption months)
I have another column "SURVEY MONTH" which represents the month that a customer took the survey.
I want to capture all redemption months 3 months prior to the survey month.
(i.e., in the dataset, if the SURVEY MONTH = 06/2022, I would ideally like to create a formula to flag all of the REDMEPTION MONTH rows that are within 04/2022, 05/2022, and 06/2022.
thanks!