Create a table from an other with adding the data of multiple columns

Question

Dear Power BI users,&nbsp;&nbsp;I have a problem with a set of data from a database.&nbsp;&nbsp;My table (Result) look like this :&nbsp;&nbsp;Columns : ID ; Name ; Month-1 ; Month 2 ; ... ; Month 12&nbsp;&nbsp;The data in Month (1-12) is decimal number.&nbsp;&nbsp;I would create in Power BI desktop querry editor a table from the table "Result" with the following columns : ID ; Name ; Month ; Data_Month&nbsp;The columns ID and Name stay the same&nbsp;&nbsp;The column Month contain the name of the columns depending of Data_month : Month 1; Month 2, ... Month 12&nbsp;The column Data_month contain the data taken in relation with the column month and the ID.&nbsp;&nbsp;&nbsp;I put an image of the initial Table "RESULT" and the desired table "REPORT".I took for the example only columns Month 1 Month 2 and month 12&nbsp;Thanks for your help,&nbsp;Simon&nbsp;&nbsp;&nbsp;

sean · Accepted Answer

Simonfrancois In the Query Editor =&gt; got to Transform Tab =&gt; select both columns ID and NAME =&gt; Unpivot Other Columns&nbsp;&nbsp;Hope this helps! :smileyhappy:&nbsp;&nbsp;

Forum Discussion

Create a table from an other with adding the data of multiple columns

2 Replies

Related content

Create custom column based on multiple rows

Create columns group

Sequential Order column based on multiple criteria

Creating multiple Audiences in PowerBI App

Multiple messages when new item created