

In that step, the condition in do-while row evaluated to false therefore aborting further iterations. The code iterated through X values until it reached value 10. If we execute this code in Excel, we will receive the following list of values.

The following is a simple VBA code representation. The idea is to create a loop that is being executed until it reaches a certain condition. Basically, every important object in PowerQuery.ĭo while loop is commonly used in object programming.

We will combine our knowledge of lists, records, functions, iterations, and looping techniques. In this blog, we will explain an advanced topic about the M language – using List.Generate to loop over a table.
