Forum Discussion
Lookupvalue or alternative
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
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])
1 Reply
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])