Linking related items within the same table-Power Query

Hey mraka9 ,

to create this

I created an inline function using the advanced editor, the code below added the custom column "Custom", which holds the result, the combinedString:

...
    #"Added Custom" = 
        Table.AddColumn(#"Changed Type", "Custom", 
        ( row ) => 
            let
            filtervalue = row[C],
            combinedString = 
                Text.Combine(
                    List.Transform(
                        Table.SelectRows( #"Changed Type" , each [C] = filtervalue )[B]
                        , each Number.ToText( _ )
                    )
                , ";") 
            in
            combinedString
        )
in
    #"Added Custom"

Hopefully, this provides what you are looking for. If not, consider creating a pbix that contains sample data, upload the pbix to onedrive, googledrive, or dropbox and share the link. If you are using Excel to create the sample data share the xlsx as well.

Regards,
Tom

Hey mraka9 ,

 

if you change this line

Table.SelectRows( #"Changed Type" , each [C] = filtervalue )[B]

to this

Table.SelectRows( #"Changed Type" , each [A] = filtervalue )[B]

the function returns what you are looking for:

Regards,
Tom