HELP NEEDED: Display average of the Last Twelve Months

[Anonymous]

Dear community, 

I am struggeling to calculate the average of the last twelve months. In the Table the amount of employees are shown for each month. 

My DAX formula currently is: 

Employees Average LTM = CALCULATE(AVERAGE(Facts[Value]), AccountStructure[AccountLevel1]="6-3 Personal",AccountStructure[AccountLevel2]="Mitarbeiter",AccountStructure[AccountLevel3]="Mitarbeiter - Übersicht", AdjustmentLevel[AdjustmentLevelName]= "Controlling", DATESINPERIOD(Period[Date_complete], MAX(Period[Date_complete]),12,MONTH))

Sadly, the value shown is completely off, as it should be around 5.989 and it shows me 35.

Kind regards

Nick 

[Anonymous]

Similar Problem with another DAX. 

The number is so close but still not right and I don't get why. Should be something around 260 but is 287

DAX: 

Personalkosten (inkl. Leiharbeit) LTM AVERAGE = - CALCULATE(AVERAGEX(VALUES(Period[Month]), calculate(sum(Facts[Value]), AccountStructure[AccountLevel1]="Kennzahlen IFRS", AccountStructure[AccountLevel2]="Kennzahlen zur Ertragslage",AccountStructure[AccountLevel3]="LTM Personalkosten (inkl. Leiharbeit)", AdjustmentLevel[AdjustmentLevelName]= "IFRS Konzernabschluss", DataLevel[DataLevelName]= "IST")), DATESINPERIOD(Period[Date_complete],today(),-12,MONTH))

[Anonymous]

@Shaurya @Greg_Deckler @PaulDBrown @Jihwan_Kim 

Does any of you have a guess what I am doing wrong?

[amitchandak]

@Anonymous , Try a measure like

12 Month Avg = CALCULATE(AverageX(Values('Date'[MONTH Year]),calculate(Sum('Table'[Value)))
,DATESINPERIOD('Date'[Date ],MAX('Date'[Date ]),-12,MONTH))

or check

Average of Rolling, Average of Snapshots: https://youtu.be/_pZRdLAJxxA

[Anonymous]

Sadly, I still receive the wrong numbers. Now 23,83 thousand 😕 

DAX is as following: 

Employees Average LTM = CALCULATE(AVERAGEX(VALUES(Period[Month]), calculate(sum(Facts[Value]), AccountStructure[AccountLevel1]="6-3 Personal", AccountStructure[AccountLevel2]="Mitarbeiter",AccountStructure[AccountLevel3]="Mitarbeiter - Übersicht", AdjustmentLevel[AdjustmentLevelName]= "Controlling")), DATESINPERIOD(Period[Date_complete], MAX(Period[Month]),-12,MONTH))