Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Multiple average values across one column depending on another column

Hey guys,    I want to calculate average values of column 2 depending on changing values in column 1. This average value should be written in a new column 3. The average value can be repeated in th...
Need Help
  • v-zhangti's avatar
    v-zhangti
    3 years ago

    Hi, Anonymous 

     

    You can try the following methods.

    Column 3 = CALCULATE(AVERAGE('Table'[column 2]),ALLEXCEPT('Table','Table'[column 1]))

    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.

v-zhangti's avatar
v-zhangti
Community Support
3 years ago

Hi, Anonymous 

 

You can try the following methods.

Column 3 = CALCULATE(AVERAGE('Table'[column 2]),ALLEXCEPT('Table','Table'[column 1]))

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.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Thanks!