Passing the current Record to a function

[trevb]

I created a function that I wanted to use to do a calculation when a custom column is being created.

I defined the function something like...

(Source as record, CheckVal as number) =>

When I try to use the function I am passing in the underscore but the function gives an error of "We cannot convert the value null to type Record" which suggests that _ is null.

Any thoughts on what I am doing wrong or an example of how to make this work?

Many thanks,

Trevor

[arify]

Where do you pass that "_"? For example, is it in Table.SelectRows(table, each func(_, checkVal)) ? Can you put the whole M code here?

[v-caliao-msft]

Hi Trevb,

What's do you mean by "create a function"? So far as I know, there is no an place where we can create a function. So in your scenario, please elaborate your issue, if possible provide us some screenshots, so that we can make further analysis.

Regards,

Charlie Liao