List.Accumulate calculation is unique for dynamic number of columns

[PBI_SG]

Hi There,

I have a dataset like the one below where I have a dynamic number of teams - and for each team they have their own FTE number and target performance. My goal is to get the final 2 columns based on formula (FTE*Target) for their own respective teams (teams indentified in their column headers by text after delimiter ".") 

FTE.Team1	FTE.Team2	Target.Team1	Target.Team2	Throughput.Team1	Throughput.Team2
5	7	4	2	20	14

I have built part of the formula (or so I believe) 

List.Accumulate(ThroughputTeamLists, PreviousStep, (state, current) =>
Table.AddColumns(state, current, each xxxxxx)

where ThroughputTeamLists is a list function which works out the number of columns that need to be added and the column names (in this case it holds "Throughput.Team1" & "Throughput.Team2"). Where I am unable to proceed is how to get the formula to multiply only the columns which end with the same text after delimiter as the column name itself.

Please could I get some help on how to get around this issue?

Thanks in advance 

[v-cgao-msft · Accepted solution]

Hi @PBI_SG ,

Is this your expected output?

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum