cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
snifer Post Patron
Post Patron

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.Amountlookup from table 1 (this is what i want)
100150  100300270
100120  10015050
100150     

 

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?

1 ACCEPTED SOLUTION

Accepted Solutions
Super User I
Super User I

Re: lookup value from another table

@snifer Please try this as a "New Column" in your table 2

 

LkpAmount = CALCULATE(SUM(Test124Lkp[Amount]),FILTER(Test124Lkp,Test124Data[DocumentNo]=Test124Lkp[DocumentNo]))

image.png



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

Proud to be a Datanaut !





View solution in original post

1 REPLY 1
Super User I
Super User I

Re: lookup value from another table

@snifer Please try this as a "New Column" in your table 2

 

LkpAmount = CALCULATE(SUM(Test124Lkp[Amount]),FILTER(Test124Lkp,Test124Data[DocumentNo]=Test124Lkp[DocumentNo]))

image.png



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

Proud to be a Datanaut !





View solution in original post

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Top Solution Authors
Top Kudoed Authors