How can I get an average for a row in a pivot table and/or power query? I have many columns of data. 6 of these have percentages. So I thought I would be smart and make a custom column in power query to get the average of each row of these specific 6 columns and then hide the original columns making one master average column.
I know I can make a custom column add columns by going:
=[Name]+[Name2]
But working out the average formula seems to baffle google. I know It would be easy to just throw this in a table and use the AVERAGE formula, but I want to use this data model for a specific purpose and that would negate that.
Bookmarks