In-body function

[Anonymous]

Hi folks, I'm trying to create an in-body function, can anyone help? I can create a calable external function... but in this case I would prefer to create an in-body one.

This is the code for the table

let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMlaK1YlWMgKThkqxsQA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Column1 = _t]),
CallRecursive = Table.AddColumn
(
Source,
"Recursive",
each (Recursive) => Table.SelectRows(Source, each if [Column1] = 0 then 1 else [Column1] * @Recursive([Column1] - 1))

)
in
CallRecursive

[lbendlin]

ok, what is your question?

[Anonymous · Accepted solution]

I didn't know how to close this issue, I was able to find what I was looking for:

let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMlaK1YlWMgKThkqxsQA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Column1 = _t]),

#"Changed Type" = Table.TransformColumnTypes(Source,{{"Column1", type number}}),

//----------------------
Factorial = (num) => if num = 0 then 1 else num * @Factorial (num-1) ,
//----------------------

#"Added Custom" = Table.AddColumn(#"Changed Type", "Factorial", each Factorial([Column1]))
in
#"Added Custom"