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
Super 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)