I want to create a dynamic filter, which always gives me the previous 12 months from a date variable. For example, if I run the query today, on the 24th of February 2021, I want data between the 1st of February 2020 to the 31st of January 2021. I have tried the INTNX function, but I can't get it to do what I want. How do I do this?
... View more