Lookupvalue or alternative

[Anonymous]

Hi Experts 

I have two table both with a Million rows of data. Table A

Product Ref (text) 

Value (number)

Table B 

Product Ref (text) as per Table 

Both tabke are joined via a product key table which has distinct values (Product Ref)

As we have multiple entries in Table A for Product Key..

How can I get the values from table A into B. Power Query on merger crashes 

[nirrobi · Accepted solution]

HI,

if there re multiple value for product A in table A which value you wish to bring to table B?

you can use the aggregation funcion like sum avg etc.

lookupvalue can get data from table B (unique) to table a pretty easily althoght most of the time the modeling handle this requirment pretty good

I find 2 function to acheive this calc

FROM A2 = CALCULATE( SUM( TableA[Column2] ) )

FROM A1 =

SUMX(

RELATEDTABLE( TableA ) ,

TableA[Column2]

)