Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hola , su ayuda por favor , no me muestra el promedio de los importes de los 12 meses .
Que falta en mi medida DAX .
Solved! Go to 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.
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.
please show the formula for the Existencias measure.
User | Count |
---|---|
118 | |
66 | |
65 | |
56 | |
50 |
User | Count |
---|---|
182 | |
86 | |
67 | |
62 | |
53 |