Average

[jhodasoft]

good afternoon, the idea is to calculate the average of the quarterly values, can someone help me?

[beverajr]

 Dear.

need your help to solve the average of request received per month :

Date Received         Request Number

10/01/23                 AS-202222

10/02/23                 AS-202223

10/03/23                 AS-202224

10/04/23                 AS-202225

10/05/23                 AS-202226

10/06/23                 AS-202227 

[jhodasoft]

@wdx223_Daniel thank you so much!, I solve it:

Average = AVERAGEX(values(DIM_Rotacion[trimestre]),[m_evolucion_rotacion])

[wdx223_Daniel · Accepted solution]

=AVERAGEX(VALUES[Quarters],[Measure])