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
NickProp28's avatar
NickProp28
Icon for Post Partisan rankPost Partisan
5 years ago

Dear Greg_Deckler ,

 

How about I create another column to state the sequece number, so the calculation can return to first of the ID?

 

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

    Dear Greg_Deckler ,

     

    Any hits on code could be provided? I lost on the SUM part and how does lookupvalue include the FILTER for num=1 in this case

    Thank

  • 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 

     

  • ryan_mayu's avatar
    ryan_mayu
    Icon for Super User rankSuper User
    5 years ago

    you are welcome