Forum Discussion
lookup value from another table
Hi i got 2 table
| table 1 'RECO GL DK SALE | table 2 RECO EAST DK SALE | |||||
| Document No. | Amount | Document No. | Amount | lookup from table 1 (this is what i want) | ||
| 100 | 150 | 100 | 300 | 270 | ||
| 100 | 120 | 1001 | 50 | 50 | ||
| 1001 | 50 |
I wanna to do this
AMOUNT GL look reco = LOOKUPVALUE('RECO GL DK SALE'[Amount],'RECO GL DK SALE'[Document No.],'RECO EAST DK SALE'[Document No.])
but I got an error because in table 1 there are multiple line in tabel 1
A table of multiple values was supplied where a single value was expected.
how i can have the sum of these lines in table 1?
Anonymous Please try this as a "New Column" in your table 2
LkpAmount = CALCULATE(SUM(Test124Lkp[Amount]),FILTER(Test124Lkp,Test124Data[DocumentNo]=Test124Lkp[DocumentNo]))
1 Reply
- PattemManohar
Community Champion
Anonymous Please try this as a "New Column" in your table 2
LkpAmount = CALCULATE(SUM(Test124Lkp[Amount]),FILTER(Test124Lkp,Test124Data[DocumentNo]=Test124Lkp[DocumentNo]))