Add Average of selected rows as a new column

[Anonymous]

hi there,

I would like to add an extra column calculating average of highlighted rows, however I can only add average of the columns.

Such function is available in excel, how should I achieve this in Power BI?

[v-easonf-msft · Accepted solution]

Hi, @Anonymous 

You have to sum the values and divide by the number of columns in Dax. If the table has a large number of columns, it is not recommended to use dax for the calculation of the row average. Please try to add custom column in Power query.

1. Select the columns that needs to be operated

2. 'Add Column' ->'Statistics' ->'Average'

Result:

Best Regards,
Community Support Team _ Eason

[jcalheir]

Hi

You can use AVERAGEX to do across multiple columns

https://docs.microsoft.com/pt-pt/dax/averagex-function-dax

Kind regards,
José
Please mark this answer as the solution if it resolves your issue.
Appreciate your kudos! 🙂