Forum Discussion

Parihar1980's avatar
Parihar1980
Helper II
8 years ago
Solved

Return Column from another table in DAX

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 

  • Hi Parihar1980,

     

    New a calculated column in Table1:

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

    Best regards,

    Yuliana Gu

2 Replies

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee

    Hi Parihar1980,

     

    New a calculated column in Table1:

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

    Best regards,

    Yuliana Gu

  • Anonymous's avatar
    Anonymous
    Not applicable

    Parihar1980,

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