Forum Discussion
Helper IVReplacing columns with rows
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:
- Add an Index column(from 1).
- Right click on Index column, select "Unpivot other columns".
- Click on "Attribute" column, select "Group By".
- Set "Group by" like below. You will get expect result.
Regards,
- Add an Index column(from 1).
Microsoft EmployeeHi,
Once you have the 2nd table:
| Avg of A | Avg of B | Avg of C | Avg of D | Avg of E |
| 16 | 9 | 7 | 14 | 7 |
You can select all columns (click first column, then shift+click last column), right click, pick "Unpivot Columns". That will produce exactly what you want :)
aktripathi2506Hi,
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.
- arify
Sorry, I don't have much knowledge about the Service, we'll need someone else's help on that.
Thanks
v-sihou-msftIn 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:
- Add an Index column(from 1).
- Right click on Index column, select "Unpivot other columns".
- Click on "Attribute" column, select "Group By".
- Set "Group by" like below. You will get expect result.
Regards,
- Add an Index column(from 1).