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
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