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)...
Anonymous Please try this as a "New Column" in your table 2
LkpAmount = CALCULATE(SUM(Test124Lkp[Amount]),FILTER(Test124Lkp,Test124Data[DocumentNo]=Test124Lkp[DocumentNo]))
PattemManohar
Community Champion
Community ChampionAnonymous Please try this as a "New Column" in your table 2
LkpAmount = CALCULATE(SUM(Test124Lkp[Amount]),FILTER(Test124Lkp,Test124Data[DocumentNo]=Test124Lkp[DocumentNo]))