Forum Discussion

PBI_SG's avatar
PBI_SG
Regular Visitor
2 years ago
Solved

List.Accumulate calculation is unique for dynamic number of columns

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.Team1FTE.Team2Target.Team1Target.Team2Throughput.Team1Throughput.Team2
57422014

 

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 

 



1 Reply