Forum Discussion
Create a NEW column inside matrix ?
Hi,
I have an loaded data into PowerBI and selected the TABLE visulization(Left side of the Picture). I need to convert the table in the left side into right side and i need to create an additional column by multiplying "PIMB * QM".
Can anyone help me to solve this problem?
Hey,
I would recommend to use the "Pivot Column" function from the Querd Editor, this helps to transform a long table into a wide table.
From
To this
You can create your new column m3 = m1 * m2 either in Power Query or with DAX
Basically it's a good idea to consider a row in a table as observation with various measurements. An observation should always be unique but can consist of various keys. From your example I would consider your column "Time" as key. During one observation two measurements have been taken "PIMB" and "QM".
For this reason I would Pivot the column "Determinant_Name".Hopefully this gives you an idea
Regards
Tom
2 Replies
Hey,
I would recommend to use the "Pivot Column" function from the Querd Editor, this helps to transform a long table into a wide table.
From
To this
You can create your new column m3 = m1 * m2 either in Power Query or with DAX
Basically it's a good idea to consider a row in a table as observation with various measurements. An observation should always be unique but can consist of various keys. From your example I would consider your column "Time" as key. During one observation two measurements have been taken "PIMB" and "QM".
For this reason I would Pivot the column "Determinant_Name".Hopefully this gives you an idea
Regards
Tom