Combine all result if Lookupvalue to one

[Anonymous]

Hi all, please for help.

I have two tables,
table A

Table B

I'm looking for formula which will for each Product in Table A find all projects in Table B a put them to column "used in project" as you can see in result Table A

result Table A

Thank you for help

[ryan_mayu]

@Anonymous 

you can create a measure

Measure = CONCATENATEX('Table B','Table B'[project],",")

and so item with no data

or you can do merge tables in PQ

then group by

= Table.Group(#"Changed Type", {"product used in project"}, {{"project", each Text.Combine([project],","), type nullable number}})

pls see the attachment below

[Anonymous]

thank you,
at real table A and B are much more comlex and PQ cant be used because some important columns are add/modified by dax formulas.
And I need get used projects to table A column, because reasult will be used in slicer. 

[ryan_mayu · Accepted solution]

you can also try this

Column = CONCATENATEX(RELATEDTABLE('Table B'),'Table B'[project],",")