Look up value

[drmakberp]

I have 2 tables and need to get the result, if len = 10 same value as Column A, if =11 lookup value Column B from Table 2.

Thanks for helping !

	Table 1				Table 2
Len	Column A		Result		Column A		Column B
10	1234567890		1234567890		12345678900		9876543210
11	12345678900		9876543210		22222222222		8888888888
10	1111111111		1111111111		33333333333		5555555555
11	22222222222		8888888888
11	33333333333		5555555555

[v-yanjiang-msft · Accepted solution]

Hi @drmakberp ,

According to your description, here's my solution.

Create a measure.

Result =
IF (
    MAX ( 'Table 1'[Len] ) = 10,
    MAX ( 'Table 1'[Column A] ),
    LOOKUPVALUE (
        'Table 2'[Column B],
        'Table 2'[Column A], MAX ( 'Table 1'[Column A] )
    )
)

Or create a calculated column in Table 1.

Result column =
IF (
    'Table 1'[Len] = 10,
    'Table 1'[Column A],
    LOOKUPVALUE ( 'Table 2'[Column B], 'Table 2'[Column A], 'Table 1'[Column A] )
)

Get the correct result.

I attach my sample below for reference.

Best Regards,
Community Support Team _ kalyj

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