Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Recursive function in Power Query

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.