Powerquery: how to iterate/loop parameters list?

Viewed 32

How to substitute code below with compact loop?

let        // SourceX are a table type variables
    Source0 = SourceTable,
    Source1 = fnCheckId(Source0, "T"  ),
    Source2 = fnCheckId(Source1, "PR" ),
    Source3 = fnCheckId(Source2, "Fen"),
    Source4 = fnCheckId(Source3, "XAL"),
    Result  = Source4
in  Result

Tried this:

let
    ParametersList = {"T","PR","Fen","XAL"},
    Result  = fnCheckId(Source, each ParametersList{_})
in  
    Result

Estimated Output: the same Result table as for the 1st example with no loop.

Returns following Error:

Expression.Error: We cannot convert a value of type Function to type Text.
Details:
    Value=[Function]
    Type=[Type]

Returns following Error:

0 Answers
Related