Create a calculated column using join

[Anonymous]

Hi,

I have the 2 tables as following.

Table1:

Department	ID
A	10
B	11
C	12
D	13
E	14

Table2:

Department	ID
A	10
	10
	10
	10
	11
	11
	11
	12
	12
	12
	12
	13
E	14

Create a new column Department1 in a Table2

Using dax query how to create a column using join 

Expect as following output:

Table2:

Department	ID	Department1
A	10	A
	10	A
	10	A
	10	A
	11	B
	11	B
	11	B
	12	C
	12	C
	12	C
	12	C
	13	D
E	14	E

Thanks in Advance,

Priviya .P

[v-frfei-msft · Accepted solution]

Hi @Anonymous ,

To create a calculated column as below.

depth2 = LOOKUPVALUE('Table'[Department],'Table'[ID],'Table (2)'[ID])