Forum Discussion
Helper VHow/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 KongIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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.