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...
Need Help
Tips and Tricks
  • 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])
ArunkumarK's avatar
ArunkumarK
Icon for Helper I rankHelper I
7 years ago

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
7 years ago

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]))). "