Average last six months not including the current month

[elimey]

I have a table of data that shows the values for each attribute at the end of each month. like below:

The data model is pretty simple. I have created an Autocalender with a MonthEnd column and the data model look like this:

What I need is a measure that calculates the average of the past six months, not including the current month. 
For instance:

- for 12.2021, we need to calculate the average of 11.2021-06.2021

- for 11.2021, we need to calculate the average of 10.2021-05.2021

The ultimate goal is to compare the value for the current month with the average of the past 6 months.

I wrote this measure: 

AVG_LAST_SIX_MONTH =

CALCULATE( AVERAGE(DPD[Value]), DATESINPERIOD('Calendar'[Date], MAX('Calendar'[Date])-1, -6, MONTH))

But the result is not correct: 

can someone tell me where am I doing wrong?

[elimey · Accepted solution]

but this works perfectly:

AVG_LAST_SIX_MONTH =

CALCULATE (

SUM ( DPD[Value] ),

DATESINPERIOD (

'Calendar'[Date],

EOMONTH ( MAX ( 'Calendar'[Date] ), -1 ),

-6,

MONTH

)

) / 6

now I am confused. What does Average do?

[amitchandak]

@elimey Try like, last 6 month before selected month

AVG_LAST_SIX_MONTH =
CALCULATE( AVERAGE(DPD[Value]), DATESINPERIOD('Calendar'[Date], eomonth(MAX('Calendar'[Date]),-1) , -6, MONTH))