Good Morning! I need to create a metric to compare sales for this month (until today) with sales for the same month last year, but in equal periods.
I made a metric that compares the months, but I don't buy in equal periods being:
SELECT IFNULL(SUM(SALES),0) FOR PREVIOUS (Month/Year (Data),12)
❌ So he compares the following dates:06/01/2021 until 06/23/2021 (today) x 06/01/2020 until 06/30/2020.
✔️ I need him to compare the same dates being:06/01/2021 until 06/23/2021 (today) x 06/01/2020 until 06/23/2020 (today).
Thank you so much for your help!
Best answer by Michael Ullock
View original