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
      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        Hi Phil,

         

        Thanks for the rpsonses.

         

        My table TimeZone only has one value - 10.

        I don't see creating a relationship for this table is the best solution and it seems quite silly to do so.

        Why can't I use this value as a parameter and then refer to it when I add my new column in Table [A]?