Forum Discussion

aktripathi2506's avatar
aktripathi2506
Icon for Helper IV rankHelper IV
10 years ago
Solved

Replacing columns with rows

Hi,   In my table suppose I have 5 column A, B, C, D and E. I have values for them.   Example:   A B C D E 5 22 15 32 4 10 4 8 25 9 11 9 6 4 4 21 4 8 12 11 ...
Need Help
  • v-sihou-msft's avatar
    v-sihou-msft
    10 years ago

    aktripathi2506

     

    In Power BI Desktop, you can directly use your large input table and return the average of each item without exporting the data at all. Please refer to steps below:

    1. Add an Index column(from 1).
    2. Right click on Index column, select "Unpivot other columns".
    3. Click on "Attribute" column, select "Group By".
    4. Set "Group by" like below. You will get expect result.

    Regards,

aktripathi2506's avatar
aktripathi2506
Icon for Helper IV rankHelper IV
10 years ago

Hi,

 

I have a big input table, which has several columns including columns A, B, C,D and E.

 

2nd table I am getting is as a result. Do you know any way to use this table as an input other than exporting the data and uploading it again to power bi and then doing unpivot the columns.

 

Because I want less mannual efforts.

 

Thanks.

v-sihou-msft's avatar
v-sihou-msft
Icon for Microsoft Employee rankMicrosoft Employee
10 years ago

aktripathi2506

 

In Power BI Desktop, you can directly use your large input table and return the average of each item without exporting the data at all. Please refer to steps below:

  1. Add an Index column(from 1).
  2. Right click on Index column, select "Unpivot other columns".
  3. Click on "Attribute" column, select "Group By".
  4. Set "Group by" like below. You will get expect result.

Regards,