Custom Function Error

[stvcdms]

Hello,

I am very new to make custom functions, but I am running into an error on the following function. I have an Employee table and want to flatten the employee - manager relationship. Before making it recursive, I just tried to make a single join function. I keep getting and error with how I am trying to pass the coumns to the Table.AddJoinColumn() function.

Below is the function and query calling it.

fnFlattenHierarchy

(HierarchyTable, ChildKeyColumn, ParentKeyColumn) =>
let
Source = Table.AddJoinColumn(HierarchyTable,{"ParentKeyColumn"},()=>HierarchyTable,{"ChildKeyColumn"},"NewColumn")
in

Source

Flattened Employee Table

let
Source = fnFlattenHierarchy(Employees, "EmployeeKey", "ParentEmployeeKey")
in
Source

Error

[Expresssion.Error] The Column 'ParentKeyColumn' of the table wasn't found.

[Greg_Deckler · Accepted solution]

 ibeleive that putting double quotes around ParentKeyColumn you are having it be treated as a string instead of a variable.

[stvcdms]

Well that was easy! Worked like a charm. Hopefully this is an OK approach to making it recursive, thanks for the help!

[Greg_Deckler]

I have a blog post on recursion with "M". Different problem, but recursion is recursion:

https://community.powerbi.com/t5/Community-Blog/Using-Recursion-to-Solve-Hex-to-Decimal-Conversion/b...