Concatenate child table rows in parent's new column in PowerBi / PowerQuery

Question

i'm trying to achieve this report with powerquery:

parent - child related table transformation

I thought that it will be a very simple "Table.SelectRows('ChildTable', each [Id] = [ParentId])" followed by a concatenation... but i can't get it work. SelectRows function expects literal as comparator and i'm not able to find a workaroud.

Any help is appresiated.

Thanks.

Answer 1

Here's a way: Merge your two tables, set up like this...

and you'll see this...

Then add a new Custom Column, set up like this...

and you'll see this...

Then click the button to expand or extract the List values in the Custom column, and click on "Extract Values..."

and select to use a Comma as a delimiter...

and you'll see this...

Then you can rename the Custom column to ChildNames and delete the Id and ChildTable columns to end up with what you want...