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:

 

 

 

 

v-janeyg-msft's avatar
v-janeyg-msft
Icon for Community Support rankCommunity Support
4 years ago

Paulo123 

 

Have you tried tamerj1's advice? If your problem has been solved, you can mark your answer as solution to close the thread. If not, please feel free to ask me.

 

Best Regards,
Community Support Team _ Janey

  • Paulo123's avatar
    Paulo123
    Frequent Visitor
    4 years ago

    I don't know if I applied the solution correctly, but I created another column in the calendar with month and year and this column was used in the calculation.