Define execute for all rows in Table.AddColumn

[amirabedhiafi]

In Table.AddColumn function, which default parameter is used to define execute for all rows?

• Each Row
• Each
• Allows
• All

[amirabedhiafi · Accepted solution]

The third parameter to this function is a columnGenerator as function - see the documentation here  you can use the each expression there, as illustrated in the example.

BTW if we add a Custom Column via the UI and use the displayed dialog box, we don’t have to write the each expression just the condition - the UI will write the rest of the code for.