#EXCEL POWER QUERY EXAMPLES CODE#
You can use this code as a general template for other series you want to make. Y = Number.Factorial( ) ], // Turn into factorial () =>, // x = increasing series, y = factorialĮach + 1, // increment x by 1 in each step The first three records would look like: Without selector, List.Generate returns a list of records With that in mind, have a look at the following examples. Optionally you can specify an optional selector in argument 4 to determine which values to return. You can use this condition to limit the amount of values to return. This loop continues until a value does not meet the condition. Then the function tests the next value against the condition. If the value satisfies the condition, it stays. The function then continues to the next value, generated by the function in argument 3.įrom here, the function tests if the next value satisfies the condition in argument 2. If the first value satisfies the condition, it remains. Before returning a result, the function test whether the initial value satisfies a condition. The function starts with an initial value (the value to start the series with).
Optional selector // selects part of the result Next as function, // generate next list value Initial value, // the starting value(s) in the listĬondition as function, // if the value satisfies the condition
0 kommentar(er)
