SUM last 12 months

[joshua1990]

Hello everybody,

I would like to use the results of the last 12 months as a parameter or as a basis for later calculations.

That the measure should be the sum ('Table1'[Values]) for the past 12 months, but only for completed months. The current month should not be considered. Furthermore, the normal months should not be used, but business months. For this, the calendar table has a column ('Calendar'[B_Month]) that has the business months in the format 'MMM'.

The following approach is not working:

=CALCULATE(SUM(Tabel1[Values]);DATESBETWEEN(
'Calendar'[Date];NEXTDAY( SAMEPERIODLASTYEAR(LASTDATE('Calendar'[Date])));
LASTDATE(PREVIOUSMONTH('Calendar'[Date]))))

Does anyone have an idea?

Best Regards

Joshua