Return Column from another table in DAX

[Parihar1980]

I have 2 table 

table 1

id name 

1   A

2   B

3   C

table 2

EMpid   date

1           11-02-2017 

2            11-02-2014

3            11-02-2013

I want to explore Date column in table 1 using join or any mathod so that I get Date column as output 

[v-yulgu-msft · Accepted solution]

Hi @Parihar1980,

New a calculated column in Table1:

Date =
LOOKUPVALUE ( table2[date], table2[EMpid], table1[id] )

Best regards,

Yuliana Gu

[Anonymous]

@Parihar1980,

You can use RELATED function to get your date column from table 2 if you have relationship between these tables.