Sales (last N months) = CALCULATE ( SUM ( Sales[Sales] ), DATESINPERIOD ( ‘Date'[Date], MAX ( ‘Date'[Date] ), – [N Value], MONTH ) )