Recursive function in Power Query

[Anonymous]

I have a table that I need to expand possibly by using recursion in M language for Power BI report.

Each ID is contained in multiple Keys and each Key could contain multiple IDs. I need to expand this table with new columns to traverse so that for each Key I list all IDs that are related to it. This should go back and forth between ID and Key columns placing ID and Key values in new columns until traversing reaches the end, because there are so many ID and Key combinations.

This problem is too advanced for me so I need help solving it.

[ppm1 · Accepted solution]

Please see this article with M code that does what I think you are describing.

Guest Post: Using List.Accumulate for Input/Output Genealogy – The BIccountant

Pat