cancel
Showing results for
Did you mean:
Frequent Visitor

## 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
1 ACCEPTED SOLUTION

Accepted Solutions
Super User

## Re: How to do an average of multiple columns?

@MichalHoltz you right!

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

Proud a to be a Datanaut!
6 REPLIES 6
Super User

## Re: How to do an average of multiple columns?

@MichalHoltz

create a measure;

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

Proud a to be a Datanaut!
Frequent Visitor

## Re: How to do an average of multiple columns?

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]))

Super User

## Re: How to do an average of multiple columns?

@MichalHoltz you right!

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

Proud a to be a Datanaut!
Frequent Visitor

## Re: How to do an average of multiple columns?

@vanessafvg it works! Thanks a lot!!

Frequent Visitor

Thanks it worked

Highlighted
Member

## Re: How to do an average of multiple columns?

I don't know the full model, but wouldn't it make more sense to change the datamodel into a thin fact table with App1-3 as a category, instead of building measures like this?

Would seem to be more alligned with best practice.