Total Revenue MTD, but from 2 days ago - Not working

[sublog]

Total Revenue MTD Prior Day = TotalMTD( [Total Revenue], DATEADD(LASTDATE('Calendar'[Date]),-2,DAY))

My calendar table extends to the end of the current calendar month. I've tried all kind of variations such as lastdate, dateadd, etc and it only gives me the current MTD totals. 

I assume it's because my calendar table extends to the end of the month. Just need a way to get around it. Honestly spent over an hour trying various things and nothing I tries work. 

[amitchandak]

Instead of end date, try endofmonth. If does not work.  If possible please share a sample pbix file after removing sensitive information.

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.

My Recent Blog - https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601
Thanks

[sublog · Accepted solution]

I think this works... Which you gave me the idea. 

Total Revenue MTD Prior Day =
TOTALMTD (
[Total Revenue],
DATESBETWEEN (
'Calendar'[Date],
STARTOFMONTH ( 'Calendar'[Date] ),
TODAY () - 2
)
)