Calculated Column or Measure?

[one3nine0]

This is all in PowerPivot 2010.

I have an invoice table with: Invoice number, Part Number, Quantity, and Price.

I also have two tables with: Part Number, Part Name. There two tables are because they are two different categories of products.

I want to have a single column that will combine all of the part names that belong to an invoice number.

Example would be:

Invoice table:

Invoice #	Part Number	Quantity	Price	Related 10000 Name	Related 30000 Name
1	10125	2	100.00	Apples
1	30524	1	50.00		Lettuce

<tbody>
</tbody>

I want to have a column that would say: "Apples Lettuce"
Even better, would be the column would say "Apples Apples Lettuce"

Is this possible in a calculated column or a measure?

If I combined the tables with product names so there is only one related column, would it make it easier to get to "Apples Apples Oranges"?

 

[one3nine0]

Oh, there will also be some products that do not have names in the related tables, as they will be excluded from the project I will be working on