Multiply a column with a constant in Power Query

[themistoklis]

Hello all,

I would like to multiply all values in a column with a specific constant using PowerQuery

I want the result will be displayed on the same column and not a new one.

Does anyone know how to do that?

[themistoklis · Accepted solution]

Hello @Zubair_Muhammad,

Thank you for teh reply. This creates a new column and i want to avoid that. I want to do the operation straight to the column in one step.

I managed to find the following script which does the trick actually.

= Table.ReplaceValue(#"Renamed Columns", each [SubTotal], each [SubTotal] * -1,Replacer.ReplaceValue, {"SubTotal"})

[Zubair_Muhammad]

Hi @themistoklis

its here

First select the column then

[themistoklis · Accepted solution]

Hello @Zubair_Muhammad,

Thank you for teh reply. This creates a new column and i want to avoid that. I want to do the operation straight to the column in one step.

I managed to find the following script which does the trick actually.

= Table.ReplaceValue(#"Renamed Columns", each [SubTotal], each [SubTotal] * -1,Replacer.ReplaceValue, {"SubTotal"})

[Zubair_Muhammad · Accepted solution]

@themistoklis

May be you used the ADDCOLUMN tab instead of TRANSFORM tab

Both have this functionality

Use this button from the TRANSFORM tab, it won't add a column

[themistoklis]

@Zubair_Muhammad

You are right. I didnt notice that.

Thanks