Welcome to deBUG.to Community where you can ask questions and receive answers from Microsoft MVPs and other experts in our community.
0 like 0 dislike
in Power BI by 27 29 37
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.

1 Answer

2 like 0 dislike
by 154 174 350
selected by
Best answer

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:


  1. In Power BI Desktop, Click on "Transform Data" to open "Query Editor".
    Transform Data in Power BI
  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
    Add Column in Power BI Power Query
  4. Then select the columns that you would like to calculate its average as a new column.
    Get the average of selected columns in Power BI
  5. From the above ribbon, click on "Statistics".
    Create Avergare column in Power BI
  6. Select the "Average" option.
    How to create an average column for other columns in Power BI
  7. Great, the new average column has been created based on the selected columns as stated below.
    avergare column in power BI based on other columns

See Also

by 27 29 37
0 0
Thanks a lot Mohamed for this detailed answer
If you don’t ask, the answer is always NO!