Help Creating a Table to Average Multiple Different Columns

[Jacob-Celadon]

Hello!

I currently have a table that I am importing that includes 48 columns in it. These are each labeled "Ch01", "Ch02", "Ch03", and so on.

I am trying to create a new table which contains 2 columns, the first one being the column name from original table (so Ch01 for the first row, Ch02 for the 2nd row, ...) then where the 2nd column is the average value for that column channel name. So the first row the 2nd column would be the average value from "Ch01". Is there an easy way to do this in PowerBi Desktop?

Example images of existing table:

Example of Output:

Sorry if this is a simple question, I am new to using PowerBI.

Thank you!

[v-zhangti · Accepted solution]

Hi, @Jacob-Celadon 

You can try the following methods.

sample data:

In the Power query-Select these 3 columns-Transform-Unpivot columns:

Result:

Is this the result you expect? Please see the attached document.

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[AlexisOlson]

First, try unpivoting your data to make it much easier to work with:
https://learn.microsoft.com/en-us/power-query/unpivot-column