Filter current day from MTD calculations

[msimmonsmcse]

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?

[amitchandak]

@msimmonsmcse , Try with time intelligence and date table

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

To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :
https://radacad.com/creating-calendar-table-in-power-bi-using-dax-functions
https://www.archerpoint.com/blog/Posts/creating-date-table-power-bi
https://www.sqlbi.com/articles/creating-a-simple-date-table-in-dax/

[mahoneypat · Accepted solution]

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

[msimmonsmcse]

Perfect, thanks!