Forum Discussion
Need help with comparinmg 2 columns
Hi there, I have two table A and B. Now i would like to sum up the Spend for all parts in Table B with a particular colour provided the parts are present in Table A. Table A Supplier, Part ...
amitchandak
Super User
Super UserAnonymous , Create a concatenated key
key = [Supplier] & " " & [Part]
If that can create 1-M join between two table
then you can filter part using A and color using B
amitchandak Thanks for the reply but i didnt want to use the combination of supplier and Part to join the two tables as they already have a relation with the Supplier.
I wanted to create a measure for the sum of the spend based on the colour and part that match with A.