I want to average up only the numbers in each row instead of the columns.

[JBennett12]

Hi, This is my first power bi and I'm having trouble finding help on averaging a row. Everything online is about averaging columns. I have tried to transpose my table, but end up with errors that won't allow me to work with it. 

I will have 22 numbers in each row that need to be averaged and about 450 rows. Is there a way to do this dynamically where I won' thave to write 450 formulas?

Thank you,

[Anonymous · Accepted solution]

Hi @JBennett12 ,

I have created a simple sample, please refer to it to see if it helps you.

Click the Home>>Transform data. Click the rows you want to calculate. Then click Transform>> unpivot columns.

Then create a measure.

Measure = CALCULATE(AVERAGE('Table'[Value]),FILTER(ALL('Table'),'Table'[date]=SELECTEDVALUE('Table'[date])))

If I have misunderstood your menaing, please provide your pbix file without privacy information and desired output with more details.

Best Regards
Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[JBennett12]

Sorry, I meant to post this as well, this is the first half of my list.