Forum Discussion

NickProp28's avatar
NickProp28
Icon for Post Partisan rankPost Partisan
5 years ago
Solved

Need help on function VLOOKUP

Dear Community,   I would like to create a new column to sum up the total weight from another table. But I dont want the total value are copying to every single row in my new table. I just want to ...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
5 years ago

NickProp28 Maybe:

 

Column = 
  VAR __ID = [ID]
RETURN
  IF([Num] <> 1),BLANK(),SUMX(FILTER('Table2',[ID]= __ID),[Weight]))

 

NickProp28's avatar
NickProp28
Icon for Post Partisan rankPost Partisan
5 years ago

Dear Greg_Deckler ,

Thanks for the feedback.
Following ur code but I encounter some issues. 

TABLEA's weight cant be put on this part