AYUDA .. MEDIDA DAX PROMEDIO

[JoseLuisC]

Hola , su ayuda por favor , no me muestra el promedio de los importes de los 12 meses . 

Que falta en mi medida DAX . 

[v-zhangti · Accepted solution]

Hi, @JoseLuisC 

You can try the following methods.

12 month average = 
Var _N1=SUMMARIZE(FILTER('Table',[PERIODO]<=MAX('Table'[PERIODO])),'Table'[PERIODO],"Sum",[Measure])
Var _N2=TOPN(12,_N1,[PERIODO],DESC)
Var _Average=DIVIDE(SUMX(_N2,[Sum]),12)
return
_Average

Is this the result you expect?

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

please show the formula for the Existencias measure.