Forum Discussion
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: -...
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
Super User
Super UserAnonymous
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)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