How/where is the M language read loop?

Hi Walt1010 ,

In M, the concept of looping through rows is abstracted away. Instead, M uses functions and transformations to process data. For example, when you apply a transformation to a table, M applies that transformation to each row without explicitly showing a loop. This can make it seem like there is no control flow, but in reality, M handles it behind the scenes.

In below example, we start by loading the sample data into a table. Then, we add a new column called "Total Sales" that calculates the total sales for each row by multiplying the "Sales" column by 1.1. Notice that there are no explicit loops; the Table.AddColumn function applies the transformation to each row automatically. This is a simple demonstration of how M processes data in a functional and declarative manner.

Best Regards,
Adamk Kong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.