PDA

View Full Version : [SOLVED] Formula in Power Query to change a column's values from being positive to negative



rcdavis28
02-27-2017, 12:39 PM
Hello,

Does anyone know how to do this in power query? Is M required or is there an easier way?

Thanks!

Aflatoon
03-01-2017, 07:49 AM
Do you mean you want them all to be negative, whether they were positive or negative before, or do you want to make negatives positive and vice versa? You should be able to achieve either one through the Custom Column button on the Add Column tab.