Rolling 12 Months Profit

 Rolling 12 Months Profit =

VAR StartDate = NEXTDAY(SAMEPERIODLASTYEAR(LASTDATE('Date'[Date])))

VAR EndDate = LASTDATE('Date'[Date])

 

RETURN

CALCULATE(

[Profit],

DATESBETWEEN(

'Date'[Date],

StartDate,

EndDate))