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

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.

Watch MrExcel Video

Forum statistics

Threads
1,090,126
Messages
5,412,607
Members
403,434
Latest member
DavidCB

This Week's Hot Topics

Top