The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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!
Solved! Go to Solution.
Try this calculated column in Table1:
EXPOSURE_LIMIT_EUR = LOOKUPVALUE (Table2[EXPOSURE_LIMIT_EUR], Table2[COUNTRY_SHORT], Table1[CUSTOMER_RESIDENCE] )
Proud to be a Super User!
Try this calculated column in Table1:
EXPOSURE_LIMIT_EUR = LOOKUPVALUE (Table2[EXPOSURE_LIMIT_EUR], Table2[COUNTRY_SHORT], Table1[CUSTOMER_RESIDENCE] )
Proud to be a Super User!
User | Count |
---|---|
87 | |
84 | |
36 | |
35 | |
30 |
User | Count |
---|---|
95 | |
74 | |
67 | |
52 | |
51 |