Create a NEW column inside matrix ?

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

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: