Forum Discussion
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.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
- Anonymous2 years ago
Hi PBI_SG ,
Is this your expected output?Best Regards,
Gao
Community Support TeamIf 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
1 Reply
- AnonymousNot applicable
Hi PBI_SG ,
Is this your expected output?Best Regards,
Gao
Community Support TeamIf 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