Forum Discussion
Post ProdigyPower Query Custom Function dialog box
Functions need parameters. Parameters in the "function dialogue" can only be of basic type (plus binary)
So this will work
let
alist = {2,2,2,2,2},
SumF = (x) => List.Sum(x)
in
SumF(alist)but it won't work if your alist is a parameter, even if that parameter is "list of values".
Apart from the academic aspect - is there a business problem you are trying to solve? You may have to dive deep into Expression.Evaluate().
No, I was just interested to see if there was some trick I was overlooking ,
thanks anyway .
Richard.
Super UserFunctions need parameters. Parameters in the "function dialogue" can only be of basic type (plus binary)
So this will work
let
alist = {2,2,2,2,2},
SumF = (x) => List.Sum(x)
in
SumF(alist)
but it won't work if your alist is a parameter, even if that parameter is "list of values".
Apart from the academic aspect - is there a business problem you are trying to solve? You may have to dive deep into Expression.Evaluate().
DickenNo, I was just interested to see if there was some trick I was overlooking ,
thanks anyway .
Richard.