topic Re: Filter current day from MTD calculations in DAX Commands and Tips

Filter current day from MTD calculations

msimmonsmcse — Mon, 11 May 2020 22:02:05 GMT

I have a working measurethat shows the current MTD revenue that looks like this:

MTD Revenue= CALCULATE(SUM('Sales'[Sales Amount]), 'Date'[Month]=MONTH(TODAY()), 'Date'[Year]=YEAR(TODAY()))

How do I tweak this filter to exclude the current days revenue?

mahoneypat — Tue, 12 May 2020 01:04:38 GMT

How about continue the pattern you started for the Day level too:

MTD Revenue= CALCULATE(SUM('Sales'[Sales Amount]), 'Date'[Month]=MONTH(TODAY()), 'Date'[Year]=YEAR(TODAY()), 'Date'[Day] <> DAY(TODAY())

If this solution works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat

amitchandak — Tue, 12 May 2020 16:58:36 GMT

msimmonsmcse , Try with time intelligence and date table

MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD('Date'[Date]), 'Date'[Date] <Today())

msimmonsmcse — Tue, 12 May 2020 17:14:56 GMT

Perfect, thanks!