How to comapre 2 columns from 2 different tables with no relations and extract another column?

[MT4U]

Table 1:

A	B
A1	100
A2	200
A3	300

Table 2

A

A2

A5

A4

I need to compare table 1 and 2 (IMP: no relationship between them), then return column B for similar values of column A in both tables.

Can anyone help me?

[johnt75 · Accepted solution]

You could try

B =
CALCULATE ( MAX ( 'Table 1'[B] ), TREATAS ( { 'Table 2'[A] }, 'Table 1'[A] ) )

[johnt75 · Accepted solution]

You could try

B =
CALCULATE ( MAX ( 'Table 1'[B] ), TREATAS ( { 'Table 2'[A] }, 'Table 1'[A] ) )

[MT4U]

Thanks for the suggestion.

I tried this, but my column is not identifying inside 'Treatas'. I tried with 'Values' but no use. Column A in both tables are in TEXT format.

[johnt75 · Accepted solution]

You're adding it as a column in Table 2, not as a measure ? And you have the { } around the column reference ?