Create a NEW column inside matrix ?

[siva3012]

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?

[TomMartens · Accepted solution]

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

[Hardik · Accepted solution]

Hi @siva3012,

You can first pivot the table on the basis of Determinant Name column and then use the below calculation to create a Price column:

 

[TomMartens · Accepted solution]

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