Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
Solved! Go to 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
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
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! 🙂