Lookup value help

[Zakaria_1980]

Hi,

Please I have two Tbls in two workbooks. I used the lookup value in Workbook-Tbl2 to add the value but i got the following msg error "

can you please help me with this and I appreciate if you can send me the PBI report if you solved the issue for me.

Thanks

Workbook-Tbl1:

ID                            Value

100	500
G	634,075
K	0
22.A	365403
UY	12
Sm	545
BG	487425
17.D	3543354
fs	131
fdsf	0
yh	0
19.B	3654
125	21
365	0
20.C	4
23.F	0

Workbook _Tbl2:

Id

22.A

19.B

20.C

17.D

23.F

[v-xinruzhu-msft · Accepted solution]

Hi @Zakaria_1980 

Try the following code as a column:

Value = LOOKUPVALUE('Table'[Value],'Table'[ID],[Id])

Output:

Best Regards!

Yolo Zhu

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