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
 

Forum statistics

Threads
1,078,273
Messages
5,339,190
Members
399,288
Latest member
ossa

Some videos you may like

This Week's Hot Topics

Top