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  

ArgumentDescription
listThe List to modify.
collectionTransformThe 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.
resultTransformThe 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: