Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Adding a new column to a table using data from another table

I have an existing table that I want to add a new column to, using specifically matched data from another table. 

The table I want to add to is named 'Case'.  The table I want to pull from is called 'User'.  

I have an established relationship between 'User'[ID] and 'Case'[OwnerID] - visualizations work perfectly to resolve Case number to Case owner name for instance. 

 

What I'd like to do is populate a new column in the 'Case' table that displays the 'User'[Name] field for each line (case number).  I know I could build a conditional colum, but was hoping there was a better way to look up the value and populate

 

"Case" 
Case_NumberOwnerID
22234QRF24B34OP
22235QRF24B956T
22236QRF24BBF21
22237QRF24BP09J
  
"User" 
IDName
QRF24B34OPEric
QRF24B956TMary
QRF24BBF21Nassif
QRF24BP09JVu
  • Anonymous's avatar
    Anonymous
    7 years ago

    Doh!  I realized my mistake.  Forgot the ' around the table name.

     

    CaseOwner = LOOKUPVALUE('User'[Name],'User'[Id],'Case'[OwnerId])

3 Replies

  • The better way for this is lookup function.

    I tried it by remembering the syntax so in case if any errors correct it accordingly. LOOKUPVALUE(User[Name],User[ID],Case[OwnerID])
    • Anonymous's avatar
      Anonymous
      Not applicable

      Sorry, I should have mentioned that I did try the Lookupvalue function - this was the error "The syntax for 'Case' is incorrect. (DAX(LOOKUPVALUE(User[Name],User[ID],Case[OwnerID]))). "

    • Anonymous's avatar
      Anonymous
      Not applicable

      Doh!  I realized my mistake.  Forgot the ' around the table name.

       

      CaseOwner = LOOKUPVALUE('User'[Name],'User'[Id],'Case'[OwnerId])