List.TransformMany
This topic applies to the Power Query Formula Language which can be used with Power Query and Power BI Desktop to build queries that mashup data. See the list of function categories.
Returns a list whose elements are projected from the input list.
List.TransformMany(list as list, collectionTransform as Function, resultTransform as Function) as list
| Argument | Description |
|---|---|
| list | The List to modify. |
| collectionTransform | The collectionTransform function is applied to each element, and the resultTransform function is invoked to construct the resulting list. The collectionSelector has the signature (x as any) => … where x is an element in list. |
| resultTransform | The resultTransform projects the shape of the result and has the signature (x as any, y as any) => … where x is the element in list and y is the element obtained by applying the collectionTransform to that element. |
List.TransformMany({1, 2}, (value) => {value + 1}, (oldValue, newValue) => oldValue * newValue) equals { 2, 6 }
Show: