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:
<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"?
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"?