Forum Discussion
How do I add rows below certain cells in Power Query
Hello, I am very new to Power Query and could use some help! We have products such as Variety Packs that contain an assortment of existing products. In order to get a full count of each produc...
Hi vcan,
This is possible. You can use something like List.Accumulate(Table.ToRecords(...), ...) and analise it or few otherstrategies, but would you be able to explain why would you need it? The data tables works in a quite different way compared to e.g. Excel. Generally, there is no guarantee that the lines will be processed in a certain sequence in DAX or visual after the data is passed from the query. What is your plan for controlling after which Variety Pack any given Product A is following?
Thanks,
John