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 ta...
  • v-yulgu-msft's avatar
    8 years ago

    Hi Parihar1980,

     

    New a calculated column in Table1:

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

    Best regards,

    Yuliana Gu