I am trying to create a metric for a date last year
for example my selected date filter is 2/01/2021 - I want the answer to be 2/01/2020
I also would like to be able to subtract months as well so 02/01/2021 would be 01/01/2021
Best answer by Iva Gasparekova
Sorry for my misunderstanding of your use-case. Now I understand that you'd like to create something like Min and Max Dates Using Date Arithmetic.
Please be aware, this solution is greatly dependant on your model. Please check the example model and MAQL in our documentation and let me know if it is doable in your project.