Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
loredanaSSS
New Member

How to bring a value from table 2 in table 1

Hello,

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

CUSTOMER_IDCUSTOMER_RESIDENCE EXPUNERE 
200180046AT        144,531
200247543GB        201,882
200319582FR        199,187
COUNTRY EXPOSURE_LIMIT_EURCOUNTRY_SHORT
AUSTRIA                      50,000,000AT
MAREA BRITANIE                      50,000,000GB
FRANTA                      80,000,000FR

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

1 ACCEPTED SOLUTION
DataInsights
Super User
Super User

@loredanaSSS,

 

Try this calculated column in Table1:

 

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

 

DataInsights_0-1642686957204.png

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

1 REPLY 1
DataInsights
Super User
Super User

@loredanaSSS,

 

Try this calculated column in Table1:

 

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

 

DataInsights_0-1642686957204.png

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.