Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Replace Values from Another Table value

Hello, Need your help to write a DAX statement I have the values in Table A, which needs to be converted to the value in B The first column ID is a unique column I have the following question: -...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    5 years ago

    Anonymous 

    you can try to create a new column

    Column = 
VAR a=LOOKUPVALUE(TableB[Value],TableB[ID],TableA[ID])
return if(ISBLANK(a),TableA[Value],a)

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

Anonymous 

you can try to create a new column

Column = 
VAR a=LOOKUPVALUE(TableB[Value],TableB[ID],TableA[ID])
return if(ISBLANK(a),TableA[Value],a)

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Thank you Ryan for the prompt reply - your approach seems to be working for creating a new column

    Is there a possibility to replace the values in the same Table A (this will save lot of rework needed, as i have already designed the formulas, joined based on the Value Column in A table - Kind regards/J

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Thank you ryan_mayu  and Eyelyn Qin for your quick response. I have accepted Ryan's solution 

    Anonymous : Unfortunately i cannot merge my tables as the table is already a merged table, i just want to replace the value in Table A based on the value from other table B (as the id is key)


    The solution from ryan_mayu  worked well, but the downside is i need to create a new table, for now now, i can manage with this approach 

     

    Thanks/J