Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
themistoklis
Community Champion
Community Champion

Multiply a column with a constant in Power Query

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?

2 ACCEPTED SOLUTIONS

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"})

 

View solution in original post

@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


Regards
Zubair

Please try my custom visuals

View solution in original post

4 REPLIES 4
Zubair_Muhammad
Community Champion
Community Champion

Hi @themistoklis

 

its here

 

First select the column then

 

multiplr.png

 

 


Regards
Zubair

Please try my custom visuals

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"})

 

@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


Regards
Zubair

Please try my custom visuals

@Zubair_Muhammad

 

You are right. I didnt notice that.

 

Thanks

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.