I need to create a budget file with sales quantities, which I need to multiply with a different unit of measurement.
The base file has 5 years of data split by month. From this file I just need 1 year (12 columns). To keep it flexible, I have created a list with column names, that I need for the project. This list is called "SelectedHeaders". This column name list is used to select the columns, groupings, roundings etc.
The quantity fields are called "Forecast - Month Year" and the multiply column is called "ReportingActivity".
I want to replace the values, so I used the following formula which is working:
= Table.ReplaceValue(#"Changed Type",0,each [ReportingActivity],(a,b) => a*b ,{"Forecast - Jan 22"})
The question is, how can I use the "SelectedHeaders" list instead of fixing the column names like {"Forecast - Jan 22"}