So MTD is pretty basic and is working ok.
With my LY calculation i want to calculate up to the same day this year, even though i’m looking at the whole month of August. ie, it’s the 14th Today, i want to know what sales were up to the 14th August Last Year, the calc i’m using is giving me the whole month.
Invoice Amount MTD LY = TOTALMTD ( [Invoice Amount] , SAMEPERIODLASTYEAR ( ‘Date’[Date] ) )
One solution i’ve seen is to reduce the calendar to only include days up until todays date, and this does work, but there has to be a better solution.