Forum Discussion

MichalHoltz's avatar
MichalHoltz
Frequent Visitor
9 years ago
Solved

How to do an average of multiple columns?

I have 3 columns and would like to get the average of 3 of them. How do I do that? App1 App2 App3 1 2 1 3 2 1 2 3 5 3 4 5 5 4 3 2 5 4
  • vanessafvg's avatar
    vanessafvg
    9 years ago

    MichalHoltz you right!

     

    what about 

     

    (AVERAGE(Table2[SAP SRM Functionality])+average(Table2[SAP SRM Productivity])+average(Table2[SAP SRM Quality])+average(Table2[SAP SRM Support]))/4?

     

     

vanessafvg's avatar
vanessafvg
Icon for Community Champion rankCommunity Champion
9 years ago

MichalHoltz

 

create a measure;

 

measure = average(sum(col1) + sum(col2) +sum(col3))

MichalHoltz's avatar
MichalHoltz
Frequent Visitor
9 years ago

Thanks. I tried this but I get an error message- The AVERAGE function only accepts a column reference as an argument

What am I missing (I'm new to Dex)?

 

Measure = AVERAGE(SUM(Table2[SAP SRM Functionality])+SUM(Table2[SAP SRM Productivity])+SUM(Table2[SAP SRM Quality])+SUM(Table2[SAP SRM Support]))

  • vanessafvg's avatar
    vanessafvg
    Icon for Community Champion rankCommunity Champion
    9 years ago

    MichalHoltz you right!

     

    what about 

     

    (AVERAGE(Table2[SAP SRM Functionality])+average(Table2[SAP SRM Productivity])+average(Table2[SAP SRM Quality])+average(Table2[SAP SRM Support]))/4?

     

     

    • MichalHoltz's avatar
      MichalHoltz
      Frequent Visitor
      9 years ago

      vanessafvg it works! Thanks a lot!!

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Thanks it worked

       

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      @ 

      Is there a way of averaging multiple columns via range instead of listing them all?