Calculate Line

[Anonymous]

Hey,

I Try to add a calculated column. the new column will calcualte average number for all the parametes that include the letter "A", for example: In team Sarah the numbers that will be calculated are: 5 + 10 + 10 because they are the only numbers that under parameter that containing the letter "A", and the average will be 8.33.

Thanks!

[Anonymous]

Anyone? Please?

[TomMartens]

Hey,

if you to have the average of the sum of the columns for each row try this
new column name = ('table'[A] + 'table'[A1] + 'table'[A2])/3

Hopefully this is what you are looking for

Regards
Tom

[Anonymous]

Hey Tom thanks,
There is a formula can indicate how many headers contain the letter "A"?
I'm asking becuase the number 3 can be changed and i prefer to divide formula into formula

[v-shex-msft · Accepted solution]

Hi @Anonymous,

I think you can try to use unpivot column feature in query editor to transform your table.

Then you can simply achieve calculate multiple column and filter on header name.

Power Query Unpivot Scenarios

Regards,
Xiaoxin Sheng

[TomMartens]

Hey, unfortunately not! But maybe you can calculate the divisor using something like this:
... / (
IF(ISBLANK('table'[A]),0,1) +
IF(...)+
...
)

But then you have to take about the Divide by 0 thing

Regards
Tom

[TomMartens]

Give the final answer from Vanessa a try: https://community.powerbi.com/t5/Desktop/How-to-do-an-average-of-multiple-columns/m-p/193721/highlig...

[Anonymous]

Hi Tom, First of all thanks for the help. In the formula given by Vanessa, she divided the average of each column by the number of columns. What I need is to make an average of all the numbers under heading A (there are 3 in the example), but the calculation will be by line rather than column. Is there still a way to do this? many thanks!