Lookup value from another table with multi-column Join

Hi PBIC ,

You can try the following methods:

1. Create a new column in Table(1):

ColumnT1 = 'Table (1)'[Ref]&'Table (1)'[Date]

2. Create a new column in Table(2):

ColumnT2 = 'Table (2)'[Ref]&'Table (2)'[Date]

3. Establish a relationship between two tables based on ColumnT1 and ColumnT2:

4. Create a new calculated column in Table(1):

NewValue = CALCULATE(SUM('Table (2)'[Value]))

The results are as follows:

Best Regards,

Community Support Team _ Joey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.