Hi, I have a DAX formula for MTD I'm looking to total my sales YOY using QTD.

So today is the 12 of September I need to see all sales QTD ending today and will compare them year over year.

This is my MTD formula:

=if(month(dCalendar[dateS])=month(today()) && year(dCalendar[dateS])=year(today())&& DAY(dCalendar[dateS])<=DAY(today()),"MTD",dCalendar[MONTH])

How do I add QTD?

thanks