Add Column using value form another table

Question

Hi,&nbsp;I have 2 tables:&nbsp;Table [A]TimeZone&nbsp;How do I add another colum in [A] that will use a column a vlaue in the TimeZone table without using a Merge Query?&nbsp;The Timezone table only contains one value which is the number of hours to offset. Ideally I would like to use this value as a parameter but have not figured out how to do it.&nbsp;&nbsp;&nbsp;

phil_seamark · Answer

Hi&nbsp;Anonymous&nbsp;If you have a 1 to many relationship between Timezone (1) and Table [A] (many)&nbsp;You can add a calcualted column on Table [A] using syntax like. &nbsp;Just replace the Value with your own column.&nbsp;New Column = RELATED(TimeZone[Value])

phil_seamark · Answer

But here is an alternative that doesn't use relationships. &nbsp;My TableA has an [ID] column which I use to lookup an [ID] column in the TimeZone table&nbsp;New Column = 
var JoinCol = 'TableA'[ID]
var NewCol = CALCULATE(MAX('TimeZone'[Value]),'TimeZone'[ID]=JoinCol)
return NewCol

anonymous · Answer

Hi Phil,&nbsp;Thanks for the rpsonses.&nbsp;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]?

anonymous · Answer

Hi Phil,&nbsp;Currently both tables are independant and is NO RELATIONSHIP between them.&nbsp;Therefore I cannot use the RELATED DAX function.&nbsp;Do I have to create a relationship?

phil_seamark · Answer

Hi&nbsp;Anonymous&nbsp;It will be easier if you can create a relationship. &nbsp;Is there any reason why you can't?&nbsp;&nbsp;

Forum Discussion

Add Column using value form another table

10 Replies

Related content

Sort by another column

calculated column using another table scan

Find Most Recent Date Relative to another Date Column in Power Query

Yet another Sort by another Column error.

[PowerQuery] add (same) column from another table