Power Query - Multiple several columns with value obtained via Paramater

jonh

New Member
Joined
Mar 2, 2005
Messages
42
Hi,

I have a table containing budgeted foreign sales data by month and want to convert this to a home currency (the fx rate is obtained via a parameter). Is it possible to multiple several columns at once in power query by a value?

I know I can create new columns for each month and multiply each budgeted sales month i.e. [January] times FX rate to provide me with [Jan USD] etc., but was hoping to select all 12 months at once.

Regards,
Jon
 

Some videos you may like

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney

Watch MrExcel Video

Forum statistics

Threads
1,114,068
Messages
5,545,795
Members
410,708
Latest member
SanTrapGamer
Top