Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
Hello,
I am trying to create cumulative lists of several nested lists in a list of list. Right now I can only get it to run one specified nested list but I would like it to run on all nested list and present a list of lists with the cumulative data as a result.
Here is my list of list and in the first nested list you can see that I have some values that I want to create a cumulative list from.
= Table.ToColumns(Table.Buffer(#"Removed Columns1"))
Here I have created a operator thata create a cumulative list using List.Accumulate. But I have to specify that I want it to be the first list, BufferedTables{0}, for it to run.
= List.Skip(List.Accumulate(BufferedTables{0},{0},(state,current)=> state & {List.Last(state) + current}))
If I do not specify which nested list to run I get this error.
= List.Skip(List.Accumulate(BufferedTables,{0},(state,current)=> state & {List.Last(state) + current}))
Can this be done in a way that I do not have to hardcode the amount of lists I want it to run? instead I just want it to go through all nested lists in the list of lists.
Is the nesting level dynamic? You may want to look into recursive functions (not just iterations, true recursions).
Check out the April 2025 Power BI update to learn about new features.
Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
User | Count |
---|---|
102 | |
68 | |
45 | |
37 | |
36 |