Create Average Column Power BI

Question

How to create a column to get the average of rows values in Power BI, I have a table and I need to create a new column to show the average of selected columns to sumarize its values as a new column the average of each cell, How can I do that in Power BI.

Answer 1

How to create an Average column based on other selected columns in Power BI?

To create an average column based on selected columns in Power BI, you can follow these steps:

Steps:

1. In Power BI Desktop, Click on "Transform Data" to open "Query Editor".
   
2. On the "Queries" left side, click on the table that you would like to add the new Average column.
3. Click on the "Add Column" tab
   
4. Then select the columns that you would like to calculate its average as a new column.
   
5. From the above ribbon, click on "Statistics".
   
6. Select the "Average" option.
   
7. Great, the new average column has been created based on the selected columns as stated below.
   

---

See Also

• How To Get Top 10 In Power BI?
• How To Use Gantt Chart In Power BI?

Comments

Thanks a lot Mohamed for this detailed answer