Forum Discussion

Paulo123's avatar
Paulo123
Frequent Visitor
4 years ago
Solved

avarage

Hi, I want to calculate the average of the years considering the value of each month, with each month being the result of a sum, how can i do this in PB 01/02/2018 221 01/03/2018 893 01/0...
  • tamerj1's avatar
    tamerj1
    4 years ago

    Hi Paulo123 
    You need to iterate over the Year-Month column not the Month column. Something like

    - Med =
AVERAGEX ( VALUES ( CALENDARIO[Year Month] ), [SOMA SAIDA] )
Paulo123's avatar
Paulo123
Frequent Visitor
4 years ago

Hi, first i make a sum:

 -SOMA SAIDA = CALCULATE(SUM(EX[VALOR]),E_S[Column1]="S")

second i calculate the average:

- Med = AVERAGEX(VALUES(CALENDARIO[Date].[Mês]),[SOMA SAIDA]).

.

here we can see that the sum is working correctly:

changing the layout, i get the annual average correctly:

but i want to get an average considering all months of all selected years, as the result of this excel:

 

 

 

 

tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
4 years ago

Hi Paulo123 
You need to iterate over the Year-Month column not the Month column. Something like

- Med =
AVERAGEX ( VALUES ( CALENDARIO[Year Month] ), [SOMA SAIDA] )