How to bring a value from table 2 in table 1

[loredanaSSS]

Hello,

I need help with the next situation. I hava the next tables :

CUSTOMER_ID	CUSTOMER_RESIDENCE	EXPUNERE
200180046	AT	144,531
200247543	GB	201,882
200319582	FR	199,187

COUNTRY	EXPOSURE_LIMIT_EUR	COUNTRY_SHORT
AUSTRIA	50,000,000	AT
MAREA BRITANIE	50,000,000	GB
FRANTA	80,000,000	FR

I need tot bring from table2 in table 1 the EXPOSURE_LIMIT_EUR. I tried something but it doesn't work. Tnx!

[DataInsights · Accepted solution]

@loredanaSSS,

Try this calculated column in Table1:

EXPOSURE_LIMIT_EUR = LOOKUPVALUE (Table2[EXPOSURE_LIMIT_EUR], Table2[COUNTRY_SHORT], Table1[CUSTOMER_RESIDENCE] )