Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Add Column using value form another table

Hi,   I have 2 tables:   Table [A] TimeZone   How do I add another colum in [A] that will use a column a vlaue in the TimeZone table without using a Merge Query?   The Timezone table only co...
General Comment
Phil_Seamark's avatar
Phil_Seamark
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi Anonymous

 

If you have a 1 to many relationship between Timezone (1) and Table [A] (many)

 

You can add a calcualted column on Table [A] using syntax like.  Just replace the Value with your own column.

 

New Column = RELATED(TimeZone[Value])
  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi Phil,

     

    Currently both tables are independant and is NO RELATIONSHIP between them.

     

    Therefore I cannot use the RELATED DAX function.

     

    Do I have to create a relationship?

    • Phil_Seamark's avatar
      Phil_Seamark
      Icon for Microsoft Employee rankMicrosoft Employee
      9 years ago

      Hi Anonymous

       

      It will be easier if you can create a relationship.  Is there any reason why you can't?

       

       

      • Phil_Seamark's avatar
        Phil_Seamark
        Icon for Microsoft Employee rankMicrosoft Employee
        9 years ago

        But here is an alternative that doesn't use relationships.  My TableA has an [ID] column which I use to lookup an [ID] column in the TimeZone table

         

        New Column = 
var JoinCol = 'TableA'[ID]
var NewCol = CALCULATE(MAX('TimeZone'[Value]),'TimeZone'[ID]=JoinCol)
return NewCol